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" 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? 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. 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. Link to comment https://forums.phpfreaks.com/topic/211412-help-with-join/#findComment-1102475 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.