[DetroitGuy]

Hey guys. I am working on a search engine and having a little trouble.

How do you return the number of results found when you query a database?

For instance:

while($qry = mysql_fetch_array($result))
{

That will of course print the results however I choose to format them, but is there a way to extract how many results were found?

Thanks!

[the_mole001]

PHP Code:

echo mysql_num_rows($result); 

[Acecool]

http://us2.php.net/mysql_affected_rows / for update, delete etc..

mysql_num_rows is the right one for you

or
you can set a variable to count as it outputs..

$i++;

[DetroitGuy]

Trying that only returns 10.

I should mention that I am creating a paging system to display results which limits the page to 10 results per page.

I believe the solution lies in SQL_CALC_FOUND_ROWS.

I seem to be having a problem returning found_rows(); however. I'll work on it some more.

Yep. Got it working. Thanks you the advice however. It is always appreciated.