dynmaic menu
im trying to create a dynamic menu, with sub menus.
SELECT pcms2_contents.navorder
, pcms2_contents.ContentID
, pcms2_contents.ContentGroup
, pcms2_contents.ContentRefID
FROM
pcms2_contents
WHERE
pcms2_contents.ContentRefID = 'content'
GROUP BY
pcms2_contents.ContentGroup
, pcms2_contents.ContentRefID
, pcms2_contents.ContentID
, pcms2_contents.navorder
HAVING
NOT pcms2_contents.ContentGroup = 'Sitemap'
ORDER BY
pcms2_contents.navorder
1 Home Page
2 About
3 Services
3 Logo Design
3 Web Design
3 Print Services
4 Our work
5 Contact
here is the query i used it gets the contentgroup navorder puts the first sec of button correctly, ie home about services so forth now i want to add web design logo design under services in the nav order i add 1-5 then i put 3 for submenu