User selection from drop down menu

[Rob]

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

[Erwin Moller]

Re: User selection from drop down menu

Rob wrote:
[color=blue]
> 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[/color]

Dear Rob,

Do you expect us to look right through our internetconnect ion into your
system and see the mySQL database?

How can anybody answer such a question without knowing how your
tables/database is constructed?

DO you have a table with provinces?
DO you have a table with catagories?
DO you have a table with trades?
What are their names?
How are they related? (Foreign keys and such)

It is like me asking you this now:
"Dear Rob,
What is the shortest route to the supermarket from where I am?"

Quite impossible.

Regards,
Erwin Moller