counting records returned.

[Anon]

I would like to know the simplist way to count the number of records that are returned. for example.

if i
select * from mydb where first_name = 'jake'
what would be the simplist way to count the number of records that are returned?

[dstockto]

Use mysql_num_rows();

ie

$returned_rows = mysql_num_rows();

This is good for select statements. If you do an insert or update or delete, use mysql_affected_rows();

[cordex]

Depends on what type of db you're using.

mysql_num_rows($query_rs); would do nicely if you're using mysql
mssql_num_rows($query_rs); would work for mssql

Of course, you could also do something like this:

$i=0;
while(mysql_fetch_array($query_rs))
$i++;