larson88 Posted October 9, 2010 Share Posted October 9, 2010 I have two tables... pictures and videos... i need to get picture from pictures and video from videos... and have them ordered by there TIMESTAMP... Can someone help me with this? I never did a complex select before. Link to comment https://forums.phpfreaks.com/topic/215495-duel-select/ Share on other sites More sharing options...
frizi Posted October 9, 2010 Share Posted October 9, 2010 This problem need more explanation for instance sample tables would help. As I understand right, you need to join the tables? use Left join or Where (my option) to do this. select images.image, videos.video where videos.imgID = images.id ORDER BY videos.timestamp . Ask your best friend (google) how to proceed. Link to comment https://forums.phpfreaks.com/topic/215495-duel-select/#findComment-1120643 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.