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 <[EMAIL PROTECTED]>
>To: Paulson, Joseph V. "Jay" <[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Thursday, January 11, 2001 11:17 AM
>Subject: [PHP] Re: [PHP-DB] Easy MySQL question
>
>
>>  Paulson, 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(*)");


-- 
Paul DuBois, [EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to