Re: Easy MySQL question
| From: | Nicolas Windpassinger - Sun | Date: | Thu, 11 Jan 2001 16:35:29 +0000 |
| Subject: | Re: Easy MySQL question | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-general+get-34036@lists.php.net to get a copy of this message | ||
Joseph,
here it is:
Number of manpages in db:
<?php $sql = "SELECT count(*) FROM manpagetool.manpages";
$result= mysql_query($sql);
$number = mysql_fetch_array($result);
echo $number["count(*)"];
?>
hope that's what you were looking for,
Nicolas.
"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;
>
> (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 General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net