Php querying mysql !!

Hey everyone

If I have a simple query such as

select name from tableone where name = whatever

How can I add on a count to the end of it. In other word have something that counts the reords returned and puts that value into a variable, e.g $counttotal

Any help appreaciated ??

:thumbsup:

Here's one way.

$result=mysql_query("SELECT count(name) FROM tableone WHERE name=whatever",$linID);
$tot=mysql_fetch_association($result);


I believe there's also a mysql_num_rows which gives you the total rows returned from a result set.

Thanks bcarl

Just what I was after !!

:thumbsup: