Re: Easy MySQL question
| From: | Paul DuBois | Date: | Sat, 13 Jan 2001 02:27:28 +0000 |
| Subject: | Re: Easy MySQL question | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5836@lists.php.net to get a copy of this message | ||
At 10:10 AM -0500 1/12/01, Leonard T. Harris wrote:
What's wrong with $number=mysql_num_rows($result); echo "The total number of rows is $number";Primarily that mysql_num_rows() tells you how many rows are in the result set, which for the query in question, is 1. The *content* of that row is how many rows are in the table.
----- Original Message ----- From: Julie Meloni <julie@thickbook.com> To: Paulson, Joseph V. "Jay" <jay.paulson@viatel.com> Cc: <php-general@lists.php.net>; <php-db@lists.php.net> Sent: Thursday, January 11, 2001 11:17 AM Subject: [PHP] Re: [PHP-DB] Easy MySQL question-- Paul DuBois, paul@snake.netPaulson, Joseph V. \"Jay\" wrote:Hello everyone-- I've got a easy question that I can't seem to answer for myself. I'm running a query in MySQL and want to know how many entries are in a table and then echo that out onto a page. I thought this would be easy but I don't know why it's not working. Anyway, here's what I am doing: (open db connection) $query = "SELECT count(*) FROM Movie"; $result = mysql_query($sql, $dbLink); $myrow = mysql_result($result); echo $myrow;$myrow = mysql_result($result,0,"count(*)");