Counting amount of results

[Anon]

How can i count the records that i get. after i run a certain query and print it in a html page like :

We found 142 results that match your query.

Can someone please help me with this ..

Kthnx DeFi

[Anon]

Depends on how your code is written, but if you are looping through your results, then you can just increment a variable for every row that you print and then display that variable.

$count = 0;
while ($row = mysql_fetch_row($result)) {
$count++;
}

print "Found $count Rows";

[brousky]

MySQL as a built in counter for results. Make your query look like this ...

SELECT name,count(*) FROM table WHERE name=searchedname;

You should get a list of all names that match the name you search and the number of results as well.

[lawnmowerman]

Both of the ways listed by Rob and Bruno are valid and acceptable, but PHP offers a function which tells you how many results were returned: mysql_num_rows()

http://www.phpbuilder.com/manual/function.mysql-num-rows.php

-Rich

[Anon]

To be pedantic, mysql_num_rows returns only the affected rows after a select query.
For others type, like insert query, the function to use is mysql_affected_rows.

DeFi, take a look at the manual for exceptions using mysql_affected rows.
Bye