Creating a dynamic, database-driven dropdown menu

[BDIMedia1]

This is a fab tutorial - I have categories I have set up in database such as Computers, Laptops, Mice etc. Can you expand on the menu showing drop down categories and then a further drop down box showing the products relating to each category??? thanks

[ADatStac]

@BDIMedia1 Just set up a loop within a loop. So while you are doing the do while loop, within each category just add another query that retrieves all records that have a categoryID of the current category in the loop. Hope that makes sense

[mrschmidt82]

Thanks. This was very helpful. I do have one question though. How do you make sure you don't get identical entries to your list? If you for example have two or more rows with the same data, but only want to display them once? Hope someone can help

[SatanicSeizures]

Wow, nice tut, and FANTASTIC website, that student ought to be teaching you ae?