Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001011

Re: [PHP-DB] Easy MySQL question From: Julie Meloni (julie <email protected>)
Date: 01/11/01

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(*)"); 

-- 
+------------------------------------------------+
| Julie Meloni (julie <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: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>