Rob wrote:
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
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