Re: LIMIT
| From: | JupiterHost.Net | Date: | Mon, 03 Jul 2006 15:15:35 +0000 |
| Subject: | Re: LIMIT | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-42152@lists.php.net to get a copy of this message | ||
Bastien Koert wrote:
Your example predicates that the resultset it passed to an array which you then take the size of, which would only give you the LIMIT value if that clause is specified in the query...I see, I misunderstood the OPs question then they wanted to know that there are 25000 records that match their WHERE but only SELECT 100 of them. Gotcha ;p yeah thats pretty much got to be 2 queries, although if caching is involved it might not be that expensive...