Re: [PHP] number of records

Diana, This is how I typically do this with mysql_num_rows: $sql = "SELECT * FROM sometable WHERE field LIKE '%$field%' LIMIT 0, 30 "; $result = mysql_query($sql) or die ("Error In Query:".mysql_error()); $num_results = mysql_num_rows($result); HTH! Cory On Tue, 2002-12-10 at

[PHP] number of records

After I run a query lik this, $db->query($sql); what is the quickest way to find out how many records result? Without having to loop through them all? Thank you , Diana -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php