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 Link to comment https://forums.phpfreaks.com/topic/28793-two-mysql-rows/ 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 Link to comment https://forums.phpfreaks.com/topic/28793-two-mysql-rows/#findComment-131838 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.