"Marcjon" <[EMAIL PROTECTED]> wrote in message
> 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
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php