Fastest way...

[Anon]

Hi,

Could someone tell me which way is the fastest.
This one:
$total = mysql_query("select count(*) from table where blahblah");
$total = mysql_result($total,0);

or this one:

$total = mysql_query("select field from table where blahblah");
$total = mysql_num_rows($total);

Thanks a lot,

David

[Anon]

count(*) is absolutely the faster way.