Code: Select all
<select name="e;requiredbuilding"e;>
<option value="e;1"e;>Building 1</option>
<option value="e;2"e;>Building 2</option>
<option value="e;3"e;>Building 3</option>
</select>just a note: i am using php and mssql, not mysql...i may be able to translate mysql code to mssql, maybe
Code: Select all
building_num | building_name
----------------------------
1 building 1
2 building 2
3 building 3