Ummm... because that's exactly what you're asking for. Look over your code again. COUNT(*) returns one record in one column, one row.
---John Holmes... ----- Original Message ----- From: "William Martell" <[EMAIL PROTECTED]> To: "phplist" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, December 12, 2002 2:56 PM Subject: [PHP] Paging / Navigation Help > Hello ALL. > > Can anyone tell me why the number of rows is always 1 and count is the total > number of records in my database. > > Thanks in Advance, > William > > [snip] > > <HTML> > <HEAD> > <TITLE></TITLE> > </HEAD> > > <BODY> > > <?php > > > $db = mysql_connect("localhost", "root"); > > mysql_select_db("dallas", $db); > > $result = mysql_query("SELECT COUNT(*) as count FROM partscatalog having > count >0;",$db); > > //get number of rows returned > $number_of_rows = mysql_num_rows($result); > > if ($number_of_rows != '0') > { > while ($myrow = mysql_fetch_array($result)) > { > echo "\$number_of_rows is $number_of_rows"; > echo "count: ".$myrow["count"]."<br>\n"; > > } > } > > ?> > > </body> > </html> > > > [/snip] > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php