Date and now() function
Posted: Fri May 26, 2006 4:29 pm
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.
Thanks in advance
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.
Thanks in advance