Re: get all records but limit to 6
| From: | Torsten Roehr | Date: | Mon, 14 Jun 2004 08:09:23 +0000 |
| Subject: | Re: get all records but limit to 6 | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34773@lists.php.net to get a copy of this message | ||
"Marcjon" <marcjon@fastmail.fm> wrote in message
news:1087195758.21890.198346730@webmail.messagingengine.com...
> I think the problem is he wants to limit after he's sorted them. The
> only way I know of to do that is to do the whole query without a limit
> clause, then run through the results but only do whatever you have to do
> with the first 6.
No. The sorting is done BEFORE the limitation. So Sunmaia's query will work
as required by Gawie.
Regards, Torsten Roehr