Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001011

[PHP-DB] Easy MySQL question From: Paulson, Joseph V. \ (jay.paulson <email protected>)
Date: 01/11/01

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;

(close db connection)

I know this is wrong but I don't know how to get the results to echo out to
the page.

Thanks,
Jay 

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