simon wrote:

> Julie Meloni wrote:
> 
> 
>> 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(*)");
>> 
> 
> 
> Shouldn't  this be $query also?
> 
> $query = "SELECT count(*) FROM Movie";
> $result = mysql_query(****$sql****, $dbLink);
> $myrow = mysql_result($result);
> echo $myrow;
> 

Yes; I wasn't paying attention to that, just the use of the 
mysql_result() function.

-- 
+------------------------------------------------+
| Julie Meloni ([EMAIL PROTECTED])                  |
| Tech. Director, i2i Interactive (www.i2ii.com) |
|                                                |
|      "PHP Essentials" & "PHP Fast & Easy"      |
|            http://www.thickbook.com/           |
+------------------------------------------------+


-- 
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