thanx guys, it's working like a charm !! "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. > -- > Marcjon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php