I have a PHP form which I use to edit a record in the MySQL data base and it has a drop down list of values I would like to set the option that is held in the database to be the first one in the list so that if the user doesn't want to change the option then the database will not get overwritten with the default option
Can any one suggest a really simple solution?
Based on comment I do need help with the ability to set the selected value my HTML select
<select id="inputRegion" name="inputRegion">
<option name="inputRegion" id="inputRegion" value="Scotland">Scotland</option>
<option name="inputRegion" id="inputRegion" value="North West">North West</option>
<option name="inputRegion" id="inputRegion" value="North East">North East</option>
<option name="inputRegion" id="inputRegion" value="Yorkshire and Humberside">Yorkshire & Humberside</option>
<option name="inputRegion" id="inputRegion" value="East Midlands">East Midlands</option>
<option name="inputRegion" id="inputRegion" value="East Anglia">East Anglia</option>
<option name="inputRegion" id="inputRegion" value="London">London</option>
<option name="inputRegion" id="inputRegion" value="South East">South East</option>
<option name="inputRegion" id="inputRegion" value="South West">South West</option>
<option name="inputRegion" id="inputRegion" value="Wales">Wales</option>
<option name="inputRegion" id="inputRegion" value="West Midlands">West Midlands</option>
<option name="inputRegion" id="inputRegion" value="Northern Ireland">Northern Ireland</option>
</select>
My php comes from a query and then can get the current record's region using;
<?php echo $contact['Region']; ?>