In article <[EMAIL PROTECTED]>, php-
[EMAIL PROTECTED] 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...
Quod subigo farinam
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php