I have a Three Table :
1. Category
CID CName
1 Technology
2 Lifestyle
3 Education
4 Tours And Travels
2. Product Category
PID CID PCName
1 1 Mobile
2 1 Computer
3 1 Tablet
4 1 Laptop
3. Product Sub Category
PSCID PID PSCName
1 1 NoKIA
2 1 HTC
3 4 HP
4 4 Acer
I want to create a dynamic navigation menu using above databse recored like :-
Menu Name :- Technology (sub Menu Name :- Mobile, computer, Tablet, Laptop)
(again make sub menu for sub menu :- For Mobile, Nokia, HTC | For Laptop (HT, Acer)
pl'z guide me how we can make it............