Dear friends,

I am trying to build application in php which have category and subcategories till 3rd level. Please show me example ? Thanks

so you have a self referncing foreign key

tbl:Persons
ID
Title
Forenames
......
ManagerID 'nullable FK references tblPersons.ID

then you have your query....
its dumb but I forget the correct syntax, it should be something sort of similar to
select my,column,list from Persons as A
right join Persons as B on b.ID = a.ManagerID
right join Persons as C on C.ID = b.ManagerID

please, use left outer joins, not right outer joins

this might help --> Categories and Subcategories

itsafaircopyerhooner

Thanks r937,

I have learned a lot from you, that's anothor great things, it look like your own site, please write more tutorials on sql i have added that site to my favourite. Thanks