| 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 internetconnection 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
| 
