First of all I am on Windows 2000, with PHP and mysql installed.
I have created a fairly long form that will take input from users about what Continent, country, state(if applicable), and city they are from. The drop down box for Continent will remain static. However based upon what they choose for that value I want to limit the results of the Country list box to just those in the mysql database that belong to that Continent. (i.e)if they choose North America I want United States, Canada, and Mexico to appear. Of course after they choose the country I want the appropriate states to appear(if appropriate) and then the cities based on the country(or state).
I have searched and searched for similar code and cannot find anything that is close enough for a newbie like me to make work. I found code that used <CFOUTPUT> but I don't even think that applies to mysql databases. I believe the best way to do this is through javascript.(?) My table setup is fairly simple with ID's on each table so I can join them up and get the appropriate data.
I'm sure this has to be fairly common, I hope someone can help.
Thanks! Mike
