User selection from drop down menu

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

I have 2 drop down menus.  1 is to pick a Province and the other is to
pick a trade (plumbng electrical etc)

The user selects which province and then what trade then hits submit
which should list all entries in the table.  How would I formulate the
select statment for MySQL to display the results in a webpage.  The
variable in my form are $province and $category

Site Timeline