Help with php/mysql dropdown menu

Hi all, how would I create a menu from php/mysql that has cats and sub cats?

For instance in table 1 i have two fields catid and catname, in table 2 I have 3 fields catid, subid and subname.

How would I display something like:

catname(catid=1)
subname(where catid=1)
subname(where catid=1)

catname(catid=2)
subname(where catid=1)
subname(where catid=1)

Many Thanks

Sponsor our Newsletter | Privacy Policy | Terms of Service