# Help needed with a php mysql query

**URL:** <https://forum.kirupa.com/t/help-needed-with-a-php-mysql-query/280679>\
**Category:** Uncategorized\
**Created:** [January 30, 2009, 10:24am UTC](https://forum.kirupa.com/t/help-needed-with-a-php-mysql-query/280679 "2009-01-30T10:24:14Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sukanya\_paul](https://avatars.discourse-cdn.com/v4/letter/s/41988e/32.png) [@sukanya\_paul](https://forum.kirupa.com/u/sukanya_paul)\
**Post date:** [January 30, 2009, 10:24am UTC](https://forum.kirupa.com/t/help-needed-with-a-php-mysql-query/280679/1 "2009-01-30T10:24:14Z")

</div>

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
