I have two tables in a MySQL database
-State
Id
Name
-City
Id
Name
State Id
And i want this:
<optgroup label="Texas"> <option value="1">Dallas</option> <option value="2">Austin</option> </optgroup> <optgroup label="Florida"> <option value="3">Miami</option> <option value="4">Tampa</option> </optgroup>
I'm using mysqli
Can you help me??