I have a HTML form that has a menu/select field with some options:

<select name="Room Type" id="Room Type" onChange="KW_calcForm('total',1,-1,'#Reg Type','+','(','#No of Rooms','*','#Room Type',')','*','#No of Nights')">
<option value="0"> </option>
<option value="75.00001">Ocean Front Double Bed - $75</option>
<option value="75.00002">Ocean Front King - $75</option>
<option value="75.00003">Ocean Front King Jr. Suite - $75</option>
> <option value="155">2 Bedroom Exec Suite - $155</option>
<option value="165">3 Bedroom Exec Suite - $165</option>
</select>

So for example, if the user selects Ocean Front King - $75, the value is $75.

However, the value that gets saved into my database is 75, and not 'Ocean Front King - $75' ...

Is there anyway to save the Item Label instead of the value ???

Or any workaround?

Check your database field, is it decimal or varchar?

Check your database field, is it decimal or varchar?

varchar, why does that make a difference?
the html form saves the 'input value', but i want to save the 'item label'

Sorry, I misunderstood. I think the $ sign is striped by PHP. are you using PHP?

Try to replace the "$" with "& # 3 6;" (remove the space)

I'm sure there is a better solution, but I'm not good with PHP.

in my example, my values are 75.00001, 75.00002, etc. etc.

this is what gets saved to the database, but I'd rather have the text that goes along with it get saved instead

Ocean Front Double Bed - $75

The values are numbers because I am doing some form calculation also.

thanks

the form will post the values and not the text that goes along with it, you can use some javascript to change the values to the text you want? You need to find a way to put the text as the value if not part of the value or maybe post the text as a hidden field or something.

Is there anyway to save the Item Label instead of the value ?

Whatever is in the value field is what will be passed by the script/form, so pass that info, IE:

Not
<option value="75.00001">Ocean Front Double Bed - $75</option>
But instead:
<option value="Ocean Front Double Bed - $75">Ocean Front Double Bed - $75</option>

The values are numbers because I am doing some form calculation also.

An alternative would be to catch the numeric value with PHP, and use that to rewrite the value that gets stored, after you perform your calculations.

can someone assist with whatever they are recommending?