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 09:54, Diana Castillo wrote:
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
--
Cory Hicks [EMAIL PROTECTED]
TRI-International
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
