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
