PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Hi, I want to have a recent posts panel on my site, this will get the most recent posts from 6 tables in a mysql database.
The dates have all been inserted in the same consistent way, with the now() function. Anyone have any suggestions as to how I should do this in SQL? I want to get the most recent one from each table so six in total.
I will do six queries, one from each table im just looking for what the SQL would look like...
Will it be something like "SELECT title FROM users ORDER BY date LIMIT 1" would that do it?