Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more - View Single Post

kayla · 12-15-2005, 06:13 PM

Hi there;

Give this a try:

PHP Code:


		
			
<? $db = mysql_connect('localhost', 'username', 'password'); 



mysql_select_db('database_name'); 



$query = 'select * from this_table'; 

$query2 = 'select SUM(titles) AS qsum from this_table'; 

$result = mysql_query($query); 

$result2 = mysql_query($query2); 

$num = mysql_num_rows($result); 



$row = mysql_fetch_array($result2); 



// echo '<strong>'.$num.'</strong>'; 



echo '<p>Here are your results: '; 



echo '<strong>'.$row['qsum'].'</strong>'; ?>

hope it works for you

12-15-2005, 06:13 PM	#2 (permalink)
kayla Member Join Date: Jun 2005 Location: Tampa, Fla Posts: 37	Hi there; Give this a try: PHP Code: `<? $db = mysql_connect('localhost', 'username', 'password'); mysql_select_db('database_name'); $query = 'select * from this_table'; $query2 = 'select SUM(titles) AS qsum from this_table'; $result = mysql_query($query); $result2 = mysql_query($query2); $num = mysql_num_rows($result); $row = mysql_fetch_array($result2); // echo '<strong>'.$num.'</strong>'; echo '<p>Here are your results: '; echo '<strong>'.$row['qsum'].'</strong>'; ?>` hope it works for you