Re: Searching...
| From: | David Robley | Date: | Fri, 19 Jul 2002 06:08:43 +0000 |
| Subject: | Re: Searching... | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-20652@lists.php.net to get a copy of this message | ||
In article <20020719012550.26135.qmail@pb1.pair.com>,
webmaster@filmfind.tv says...
> in ym search page, i construct a sql query from user input to search my
> database, and i run this query to get totalresults. Then run another query
> with a LIMIT 0, 30 ending for each page. So I'm running 2 mySQL queries per
> page. My question is, is this inefficient? is there any better way i dont
> know of? or does the 2 queries not mka emuch of a difference
>
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
--
David Robley
Temporary Kiwi!
Quod subigo farinam