Drop Down

Hi,

I want to add the results or a sql query to a drop down menu. Easy right! well this is the hard part. When you have a selected a option. I want it to adjust a second drop down menu. I'll explain more

I'm making a online gallery!

I have a table for categories and another for sub categories

My first query will be listing all the categories. Once I have selected one and want it to list all the results from my second query which is all the sub categories with the category parent being the one selected.

Any ideas?

Best way would be to use a javascript that changes what is visible when you change the selection. wouldn't really be a php prob but you could use php if you submit the form everytime the user changes selection, which might be a fuss.

here's the JS you'll need:
http://js-x.com/javascript/?run=683