Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001011

Re: [PHP-DB] Easy MySQL question From: simon (simon.pospisil <email protected>)
Date: 01/11/01

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

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:  simon.pospisil <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