RE: [PHP] Searching...
| From: | John Holmes | Date: | Fri, 19 Jul 2002 01:35:55 +0000 |
| Subject: | RE: [PHP] Searching... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-108364@lists.php.net to get a copy of this message | ||
> 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 have to use two queries, so there's no getting around that. You
should be using count(*) in your first query, it'll make it faster.
SELECT COUNT(*) FROM table WHERE ...
---John Holmes...