Easy MySQL question
| From: | Paulson, Joseph V. \"Jay\" | Date: | Thu, 11 Jan 2001 16:11:47 +0000 |
| Subject: | Easy MySQL question | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-5800@lists.php.net to get a copy of this message | ||
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