Thank you all for your input. Here is the answer that I was looking for. I
am posting it here so that anyone else looking for this answer can benefit
Thank you all again for your responses.
----- Original Message -----
From: "Jay Blanchard" <[EMAIL PROTECTED]>
To: "'William Martell'" <[EMAIL PROTECTED]>
Sent: Friday, December 13, 2002 6:03 AM
Subject: RE: Paging / Navigation Question
> Or another way if you don't want a result when it's zero.
> $rslt = mysql_query("SELECT count(*) as cnt FROM tbl having cnt > 0");
> $result = mysql_query("SELECT * FROM tbl");
> $number_of_rows = mysql_num_rows($result);
> You don't have to do the count in the SQL, as John said earlier a SELECT
> COUNT(*) FROM tbl will always return one row, even if the value of the row
> is 0. Of course you could always test for that.
> CountingRows Solution #317 :^]
> I was reading your post regarding paging and SELECT COUNT(*)
> I don't understand why $number_of_rows will always equal 1.
> I thought that if you SELECT COUNT(*), that you are telling mySQL to count
> all of the rows WHERE some condition is met.
> Please explain???
> A COUNT query always returns one row, the row which explains how many
> records were counted. It is easier to understand if you know that a row is
> not necessarily equal to a record. For example, look at these count
> from MySQL monitor;
> mysql> SELECT COUNT(*) FROM tblSubscriber;
> | COUNT(*) |
> | 71896 |
> 1 row in set (0.01 sec)
> See the last line? "1 row in set (0.01 sec)" Of course this is not a
> for the record would have subscriber information over multiple columns.
> Let me know if this is clear.
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php