Reputation: 163
I found that an old code has been submitting illegal values into DB from time to time. I have a select with many options and between options there are some "Headings" that I have disabled.
MYSQL field for errorcode is varchar(2). I have found some "SU" values from that field. That means that the first option, that is disabled, gets submitted.
I looked at the page with IE, Firefox and Chrome and in all of the browsers the first option was disabled and i couldn't select it. I don't have an idea how to debug it.
How to solve this?
<td bgcolor="#E1E1E1">
<select name=errorcode[] style="width:350">
<option disabled="disabled">SU***** ***:</option>
<option value="0"> [0] SU***** ***</option>
<option value="1"> [1] SU***** ***</option>
<option value="2"> [2] SU***** ***</option>
<option value="3"> [3] SU***** ***</option>
<option value="4"> [4] SU***** ***</option>
<option value="5"> [5] SU***** ***</option>
<option value="6"> [6] SU***** ***</option>
<option value="7"> [7] SU***** ***</option>
<option value="8"> [8] SU***** ***</option>
<option value="10"> [10] SU***** ***</option>
<option value="12"> [12] SU***** ***</option>
<option value="13"> [13] SU***** ***</option>
<option value="14"> [14] SU***** ***</option>
<option value="15"> [15] SU***** ***</option>
<option disabled="disabled">PR******* ***:</option>
<option value="40"> [40] PI******** ***</option>
<option value="41"> [41] PI******** ***</option>
<option value="42"> [42] PI******** ***</option>
<option value="43"> [43] PI******** ***</option>
<option value="44"> [44] PI******** ***</option>
<option value="46"> [46] PI******** ***</option>
<option value="47"> [47] PI******** ***</option>
<option disabled="disabled">KO**** ***:</option>
<option value="50"> [50] KO**** ***</option>
<option value="51"> [51] KO**** ***</option>
<option value="52"> [52] KO**** ***</option>
<option value="53"> [53] KO**** ***</option>
<option value="54"> [54] KO**** ***</option>
<option value="55"> [55] KO**** ***</option>
<option value="56"> [56] KO**** ***</option>
<option value="57"> [57] KO**** ***</option>
<option value="58"> [58] KO**** ***</option>
<option value="58"> [59] KO**** ***</option>
</select>
</td>
Upvotes: 0
Views: 97
Reputation: 313
Try to convert your code to something like:
<select>
<optgroup label="Swedish Cars">
<option value="volvo">Volvo</option>
<option value="saab">Saab</option>
</optgroup>
<optgroup label="German Cars">
<option value="mercedes">Mercedes</option>
<option value="audi">Audi</option>
</optgroup>
</select>
More info: w3schools optgroup
It's better way to set headings.
Upvotes: 1