Here is how can you find the number of rows in a result set in PHP:

$result = mysql_query($any_valid_sql, $database_link);

$num_rows = mysql_num_rows($result);

echo "$num_rows rows found";