row counter

[Anon]

I need to count the number of rows found in my results. Like 32 matches found. Thanks

[Anon]

using MySQL ?

[Anon]

yes I am.

[Anon]

$query = "SELECT * FROM $userstable WHERE whatever";

$query_result_handle = mysql_query ($query)

or die ('topic=The requested table or database does not exist');

$num_of_rows = mysql_num_rows($query_result_handle)

[[deleted]]

'topic=The requested table or database does not exist'

I have seldom seen a worse error description that this one...

[webphp]

Another alternative would be to
select count(*) from tblName.
-Rick

[Anon]

thanks, i strive for the worst.

[[deleted]]

You're on the right track 🙂

[[deleted]]

Small note: If you use this query, you will get the number of rows as a query-result, so you must run mysql_fetch_row() to get it.