Display text instead of numerical value from database in update page
I have a dropdown menu in my insert and update pages for users to choose their timezone which writes a numerical value to the dB as follows:
<option timeZoneId="1" gmtAdjustment="GMT-12:00" useDaylightTime="0" value="-12">(GMT-12:00) International Date Line West</option>
<option timeZoneId="2" gmtAdjustment="GMT-11:00" useDaylightTime="0" value="-11">(GMT-11:00) Midway Island, Samoa</option>
<option timeZoneId="3" gmtAdjustment="GMT-10:00" useDaylightTime="0" value="-10">(GMT-10:00) Hawaii</option>
<option timeZoneId="4" gmtAdjustment="GMT-09:00" useDaylightTime="1" value="-9">(GMT-09:00) Alaska</option>
<option timeZoneId="5" gmtAdjustment="GMT-08:00" useDaylightTime="1" value="-8">(GMT-08:00) Pacific Time (US & Canada)</option>
... and so on.
On the update page, I want to display the currently selected timezone as the selected value in the dropdown, but of course it displays the value rather than the actual text (so "-8" rather than "(GMT-08:00) Pacific Time (US & Canada)". The actual text isn't saved in the database anywhere. How can I get the dropdown to display the text rather than the value as the currently selected option?