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

Reply via email to