CarbonCopy Posted October 17, 2009 Share Posted October 17, 2009 I have a table, and the relevant columns are id,url, and url-prefix. Two of my entries have these values {1,'/path/to/gallery',0} {2,'/path/to/designs',0} and 4 of my entries go like this {3,'gallery1',1} {3,'gallery2',1} {4,'designs1',2} {4,'designs2',2} If I have the url /path/to/designs/gallery1 I want to check to see if it is a valid entry or not. Is there any way to do this in 1 query? Quote Link to comment https://forums.phpfreaks.com/topic/178015-getting-two-rows-with-1-query-where-the-second-row-depends-on-the-first/ Share on other sites More sharing options...
fenway Posted October 17, 2009 Share Posted October 17, 2009 Say what? Quote Link to comment https://forums.phpfreaks.com/topic/178015-getting-two-rows-with-1-query-where-the-second-row-depends-on-the-first/#findComment-938871 Share on other sites More sharing options...
CarbonCopy Posted October 17, 2009 Author Share Posted October 17, 2009 Is there any way to select the url and prefix id from the second set of rows and get the url matching the prefix id from the second? So it would return /path/to/gallery/gallery1 instead of /path/to/gallery AND gallery1 Quote Link to comment https://forums.phpfreaks.com/topic/178015-getting-two-rows-with-1-query-where-the-second-row-depends-on-the-first/#findComment-938879 Share on other sites More sharing options...
fenway Posted October 18, 2009 Share Posted October 18, 2009 Sounds like you should be able to CONCAT() them together and simply check... Quote Link to comment https://forums.phpfreaks.com/topic/178015-getting-two-rows-with-1-query-where-the-second-row-depends-on-the-first/#findComment-938922 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.