jwk811 Posted July 6, 2009 Share Posted July 6, 2009 There are two tables for the forum I have. The original post (topic table) and all the replies are a different table. Right now the forum has the posts in order by the original. If someone replies I want it to order by most recent reply or post whichever was more recent. Hope I explained it well enough, I just don't know if this is possible with two tables. Link to comment https://forums.phpfreaks.com/topic/164997-order-by-whichever-date-is-more-recent/ Share on other sites More sharing options...
cunoodle2 Posted July 6, 2009 Share Posted July 6, 2009 I'm sure this will be moved to mysql forums. Can you write out the sql query as to what you THINK it might be? I'd image you would check the reply table first and then check the OP table. Link to comment https://forums.phpfreaks.com/topic/164997-order-by-whichever-date-is-more-recent/#findComment-870020 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.