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(*)");
>
> --
> +------------------------------------------------+
> | 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]
Shouldn't this be $query also?
$query = "SELECT count(*) FROM Movie";
$result = mysql_query(****$sql****, $dbLink);
$myrow = mysql_result($result);
echo $myrow;
--
Simon Pospisil Mail: [EMAIL PROTECTED]
Web Engineer Web: http://www.fastsearch.com/
Fast Web Media Ltd. Phone: +44 (0) 161 835 3444
Suite 1202, Sunlight House Quay Street Fax: +44 (0) 161 835 3488
Manchester, England M3 3JZ
Try FAST Search: http://www.alltheweb.com