Counting Returned Rows

[stuartc1]

Hi Folks,

Does anyone know a function for counting how many rows are returned from a Select Query (using MySQL). I have been using the following but there must be an easier way.

$Lcount=0;
while ($myrow = mysql_fetch_array($qry_det))
{ $Lcount++; }

Thanks for your help.
SC:

[Anon]

There's a function:

$result = mysql_query($query) or die("Error in query");

$number = mysql_num_rows($result);

$number = number of rows returned

[stuartc1]

Cheers, I thought there was one.. SC 🙂