Sorting 4 Different Tables By Date
I'm working with a site where there are 4+ different types of items that can be on the front page (like photos, blog posts, reviews, etc) and these are stored in 4 different database tables that really can't be combined into one table easily.
I want to sort these on the front page by date desc so the latest 5 are displayed. Currently i'm using a multiple dimension array to do this but I figure there's got to be a much easier way possibly through a MySQL view or join or something. All 4 columns have a DATE field to sort by...any ideas? All I would need to return is the type and the primary key and I'd be fine.
Any help would be appreciated.