"Marcjon" <marcjon@xxxxxxxxxxx> wrote in message news:1087195758.21890.198346730@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx > 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
