I have a page where i want the full listing of categories in a drop down box ie.\
\
Antiques & Art:Antiques (post-1900)\
Antiques & Art:Antiques (pre-1900)\
Antiques & Art\
Automotive:Automobilia:Advertising\
Automotive:Automobilia:Badges & Mascots\
Automotive:Automobilia:Branded merchandise\
Automotive:Automobilia:Lapel pins\
\
etc. etc..\
\
can i get the MySQL to output this for a dropdown box