Yes, I want my to use php to get the data i have on my database to provide the info for the drop down. I am using the select tag. Here is the scenario, i have a table of locations, which include the city and state(here it is called area). In my drop down i want to use optgroup to separate or group my cities into the different states they are in. So far this is my code:
[code] Find one near you
With this code i was able to get the result of one area and one city and it displays the next area and one city again, it doesnt list all the cities under that area,
You have any suggestions ?