Hi all,
i need to create a dropdown box which whenever user select a value in it, MYSQL will update the selected value and that selected value will no longer available inside the dropdown list. So the following user can select another available value without overwrite or duplicate the previous one in database. The default value in MYSQL database fieldname is NULL.
For example, The dropdown list contains “Audi”,“Mazda”, and “Toyota”. If first user select “Audi” and the database will stored the selection. Then second user will only see “Mazda” and “Toyota” available in the list as database already stored “Audi” in it.
I hope someone can help me out here. Many thanks 
