Paul Goepfert schrieb: > Is there a more efficient way to do this using more PHP and less mysql? Anything that helps you inside SQL to get your solution doing just one statement should be faster than doing two queries with some PHP code inbetween for "reasonable complicated" tasks. This is because the time overheads for using the connection and the socket overhead are bigger than the time won by doing the intermediate calculation "a bit" better with PHP. So, if your SQL looks somehow similar to what you would do on the PHP side: Keep it that way! OLLi -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php