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