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
help needed with a php mysql query
Moderator: General Moderators
-
sukanya.paul
- Forum Newbie
- Posts: 9
- Joined: Tue Dec 02, 2008 4:16 am
-
jothirajan
- Forum Commoner
- Posts: 69
- Joined: Tue Jan 27, 2009 12:06 am
Re: help needed with a php mysql query
try the Join query....