Hi there thats a very helpful link and will use that in up coming projects..however for my current project its a little different...i have posted another thread as need help urgently on this matter: the basic idea is to have the following "dynamic" menu
(currently i am storing the IDs of category, subcategory1 & subcategory2 in my products table but this maybe totally wrong.) and I have the category, subcategory1 & subcategory2 tables that store the category name.
here is te menu layout:
any guidence would be awesome :)