Got a little question to see if someone can help me out…
I would like to create 2 pull-down menus. The values in these pull-down boxes come from two tables in my database, one called Region, the other called Area.
What i wanted to do is, when a user selects a Region from the pull-down box, to then put values into the Area pull-down box specific to that Region.
I have set up the mysql database so the Area table has a column called RegionID which is linked to the ID of the table Region.
This is so i can do SELECT * FROM Area WHERE area.RegionID = region.ID
Could someone please tell me the code?