how to save drop down list index value to Mysql Database

Question

Hello,

 

        I am doing one project in that i have drop down list and i retrieved data to that from database. Now i want insert one record to database but in my table Id is there now i want to insert the dropdown list index value to that id. here not the selected text from drop down list. the index value i have to save.

 Here My tables 

 Columns (ID, RoomNo, Sharing) dropdown list have the Names. so now i don't want that name i want the index value of that selected dropdownlist.

 

pls can any one tell me how to do it.

 

 

Thanks