yarub Posted October 20, 2011 Share Posted October 20, 2011 First off, I'm not trying to "join" the tables like every single website is trying to tell me to do. And if I am.. it's not working. I am trying to take two different types of "post" style tables and put them into one readers column and have them sort by date. For instance.. Table 1 Post IDPost TitlePost ContentPost Date 1Title 1Content 120111018 2Title 2Content 220111019 3Title 3Content 320111020 Table 2 Post IDPost TitlePost ContentPost Date 1Blog 1Context 120111015 2Blog 2Context 220111018 3Blog 3Context 320111020 How can I query those in the manner that they would display something like.. 1, Blog 1, Context 1, 20111015 1, Title 1, Content 1, 20111018 2, Blog 2, Context 2, 20111018 2, Title 2, Content 2, 20111019 3, Title 3, Content 3, 20111020 3, Blog 3, Context 3, 20111020 Note that it's sorted by date. When joining tables, it wants me to compare the two tables. I don't want to do that. If someone can help me, I'd greatly appreciate it. Link to comment https://forums.phpfreaks.com/topic/249436-retrieve-data-from-multiple-tables-at-once/ Share on other sites More sharing options...
PFMaBiSmAd Posted October 20, 2011 Share Posted October 20, 2011 http://dev.mysql.com/doc/refman/5.5/en/union.html Link to comment https://forums.phpfreaks.com/topic/249436-retrieve-data-from-multiple-tables-at-once/#findComment-1280752 Share on other sites More sharing options...
yarub Posted October 20, 2011 Author Share Posted October 20, 2011 You're my hero. Thank you very much. Link to comment https://forums.phpfreaks.com/topic/249436-retrieve-data-from-multiple-tables-at-once/#findComment-1280835 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.