chriscloyd Posted November 28, 2006 Share Posted November 28, 2006 is there a way to get the lateset row out of two rows?im making a forum and im doing the latest post part and i want it to get the latest one from post or topics tables Quote Link to comment Share on other sites More sharing options...
Barand Posted November 28, 2006 Share Posted November 28, 2006 Do the records have a date/time column. If so,SELECT * FROM posts ORDER BY datetimecol DESC LIMIT 1will give the lastest Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.