Hi there,
I am using mySQL, and PHP4 with html templates.
I have a SIGNUP page which loads and asks the user for their name etc. There are also three drop down list boxes, one for country, one for state and another for city. I have matching tables in the database which can be used as lookup tables to populate these lists.
My problem is simply that I want the STATE drop down list box to be automatically populated once the person has selected their country and the same then goes for the CITY list.
I know that I am going to have to use javascript here but I really do not know how the heck I am going to put the javascript into the html template and get it to reload the php code and have the php code do the correct lookup in the correct table ..... while keeping it all as fast and simple as possible!
Any help would be greatly appreciated!
Many thanx
Grant
