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. Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/215495-duel-select/#findComment-1120643 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.