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 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 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. 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
Archived
This topic is now archived and is closed to further replies.