This post originated from an RSS feed registered with PHP Buzz
by Jackson Miller.
Original Post: Subqueries in MySQL 4.1+
Feed Title: CentreSource: Blog
Feed URL: http://blog.centresource.com/category/development/php/feed/
Feed Description: PHP Development company in Nashville, TN.
Today I came across a problem where I needed to find all of the threads in a forum, along with the first post and last post information. The easy (but inefficient) way is to find all of the initial posts, and then based on that result set, find all of the replies for each [...]