Sub queries
Mysql now offers sub queries/sub selects. They can help you write faster and shorter code. You dont need to do that much programming in PHP, just let mysql do the work A new thing in MySql 5 is the possibility to use something called "sql subqueries". It can be a very powerful new tool..