nobodyk Posted August 22, 2010 Share Posted August 22, 2010 Here's my table structures: folders folderid foldername status pw bfolders foldername userid imageid location I'm trying to get the "folderid" where "userid" equals let's say 10. A user can't have the same "foldername" I will give it a shot... "SELECT folders.folderid, folders.foldername, bfolders.userid, bfolders.imageid FROM folders, bfolders WHERE folders.foldername = bfolders.foldername AND bfolders.userid = 10" Quote Link to comment https://forums.phpfreaks.com/topic/211412-help-with-join/ Share on other sites More sharing options...
fenway Posted August 22, 2010 Share Posted August 22, 2010 And that doesn't work? Quote Link to comment https://forums.phpfreaks.com/topic/211412-help-with-join/#findComment-1102385 Share on other sites More sharing options...
nobodyk Posted August 22, 2010 Author Share Posted August 22, 2010 Just an update (for those that care anyways) I'm re-doing my query since my tables aren't normalized properly. Quote Link to comment https://forums.phpfreaks.com/topic/211412-help-with-join/#findComment-1102473 Share on other sites More sharing options...
fenway Posted August 22, 2010 Share Posted August 22, 2010 Keep us posted. Quote Link to comment https://forums.phpfreaks.com/topic/211412-help-with-join/#findComment-1102475 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.