Re: Re: Searching...

In article <200207191553.46721.php-general@gremlins.com.hk>, php- general@gremlins.com.hk says... > On Friday 19 July 2002 14:08, David Robley wrote: > > > You might consider running the first query just to get a COUNT(), rather > > than extracting all the resulting rows and using mysql_numrows to > > determine how many were returned > > Am I missing something? If you do a COUNT() in the query then, in general, > it'll only return 1 row. You then use this row to determine the result of the > COUNT(). IE using mysql_numrows() on this result is inappropriate. > > Nope. The OP sounded like he was pulling the entire query and doing a mysql_num_rows on it, then running the query again. Of course, I may have misunderstood what he was saying... Cheers -- David Robley Temporary Kiwi! Quod subigo farinam