Page 1 of 1

help needed with a php mysql query

Posted: Fri Jan 30, 2009 4:20 am
by sukanya.paul
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

Re: help needed with a php mysql query

Posted: Sat Jan 31, 2009 7:07 am
by jothirajan
try the Join query....