sukanya.paul Posted January 30, 2009 Share Posted January 30, 2009 hi i am facing a big problem with a mysql query i have 3 tables feat_proj pId,domain,projName,scope are the fields in this table value: 1 dom proj_name xxxxx feat_mod mId,pId,modName 1 1 mod1 2 1 mod2 feat_sec sId,mId,PId,secName 1 1 1 sec1 2 1 1 sec2 3 2 1 sec3 4 2 1 sec4 i want a query which will display proj_name mod1 sec1 sec2 mod2 sec3 sec4 in a table. Any idea how to achieve this? thanks for the help, Suk Quote Link to comment https://forums.phpfreaks.com/topic/143105-help-needed-with-a-php-mysql-query/ Share on other sites More sharing options...
Zane Posted January 30, 2009 Share Posted January 30, 2009 double posting causes lymphoma Quote Link to comment https://forums.phpfreaks.com/topic/143105-help-needed-with-a-php-mysql-query/#findComment-750531 Share on other sites More sharing options...
Chicken Little Posted January 31, 2009 Share Posted January 31, 2009 Try using JOIN. Quote Link to comment https://forums.phpfreaks.com/topic/143105-help-needed-with-a-php-mysql-query/#findComment-751558 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.