Number of Records Returned

[Thelma]

Any tips on how to count up the number of records returned from a search ?

Thanks

[Spookster]

SELECT COUNT(*) FROM TABLENAME WHERE FIELDNAME = 'foobar';

[Thelma]

Thanks!

[freakysid]

Or if you wish to know how many rows there are in the result set (the results of your query).

$sql = "SELECT COUNT(*) FROM TABLENAME WHERE FIELDNAME = 'foobar'";
$result = mysql_query($sql);
$numRows = mysql_num_rows($result);

:)