help needed with a php mysql query

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
sukanya.paul
Forum Newbie
Posts: 9
Joined: Tue Dec 02, 2008 4:16 am

help needed with a php mysql query

Post 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
jothirajan
Forum Commoner
Posts: 69
Joined: Tue Jan 27, 2009 12:06 am

Re: help needed with a php mysql query

Post by jothirajan »

try the Join query....
Post Reply