need help in this select drop down box

Hi i had a drop down box written with select and i had many options , when user selects the option it will insert this to database and when user goes to the edit form the preselected value has to be populate automatically in dropdown , but the last option is populating everytime when uses edit form.

below is the code:

insert page:

            <select name="council" id="council" name="Please select Council from dropdown box">
                <option  value="Division">Division</option>
                <option  value="Facility">Facility</option>
                <option  value="District D">District D </option>
                <option  value="District E">District E </option>
                <option  value="District J">District J </option>
                <option  value="District K">District K </option>
                <option  value="District L">District L </option>
                <option  value="District M">District M </option>
                <option  value="District N">District N </option>
                <option  value="District O">District O </option>
                <option  value="District Q">District Q </option>
                <option  value="District S">District S </option>   
                <option  value="District T">District T </option>
                <!--- Below code  is added just for temporary case ,for this drop down we need to pull all these data from databse--->
                <option  value="D 506">D 506</option>                                            
                <option  value="D 524">D 524</option>
                <option  value="D 525">D 525</option>
                <option  value="D 530">D 530</option>
                <option  value="D 531">D 531</option>
                <option  value="D 536">D 536</option>
                <option  value="D 549">D 549</option>
                <option  value="D 558">D 558</option>
                <option  value="D 562">D 562</option>
                <option  value="D 581">D 581</option>
                <option  value="D 583">D 583</option>
                <option  value="D 597">D 597</option>
                <option  value="D 598">D 598</option>
                <option  value="D 599">D 599</option>
                <option  value="D 628">D 628</option>
                <option  value="D 686">D 686</option>
                <option  value="D 698">D 698</option>
                <option  value="D 848">D 848</option>
                <option  value="D 862">D 862</option>
                <option  value="D 870">D 870</option></select>

this is edit page code:

                   <select name="council" id="council">               
               <cfoutput query="getdata">               
                <option  value="Division" <cfif council IS "#getdata.council#"> selected</cfif>>Division</option>
                <option  value="Facility" <cfif council IS "#getdata.council#"> selected</cfif>>Facility</option>
                <option  value="District D" <cfif council IS "#getdata.council#"> selected</cfif>>District D </option>
                <option  value="District E" <cfif council IS "#getdata.council#"> selected</cfif>>District E </option>
                <option  value="District J" <cfif council IS "#getdata.council#"> selected</cfif>>District J </option>
                <option  value="District K" <cfif council IS "#getdata.council#"> selected</cfif>>District K </option>
                <option  value="District L" <cfif council IS "#getdata.council#"> selected</cfif>>District L </option>
                <option  value="District M" <cfif council IS "#getdata.council#"> selected</cfif>>District M </option>
                <option  value="District N" <cfif council IS "#getdata.council#"> selected</cfif>>District N </option>
                <option  value="District O" <cfif council IS "#getdata.council#"> selected</cfif>>District O </option>
                <option  value="District Q" <cfif council IS "#getdata.council#"> selected</cfif>>District Q </option>
                <option  value="District S" <cfif council IS "#getdata.council#"> selected</cfif>>District S </option>   
                <option  value="District T" <cfif council IS "#getdata.council#"> selected</cfif>>District T </option>                   
                <option  value="D 506" <cfif council IS "#getdata.council#"> selected</cfif>>D 506</option>                                            
                <option  value="D 524" <cfif council IS "#getdata.council#"> selected</cfif>>D 524</option>
                <option  value="D 525" <cfif council IS "#getdata.council#"> selected</cfif>>D 525</option>
                <option  value="D 530" <cfif council IS "#getdata.council#"> selected</cfif>>D 530</option>
                <option  value="D 531" <cfif council IS "#getdata.council#"> selected</cfif>>D 531</option>
                <option  value="D 536" <cfif council IS "#getdata.council#"> selected</cfif>>D 536</option>
                <option  value="D 549" <cfif council IS "#getdata.council#"> selected</cfif>>D 549</option>
                <option  value="D 558" <cfif council IS "#getdata.council#"> selected</cfif>>D 558</option>
                <option  value="D 562" <cfif council IS "#getdata.council#"> selected</cfif>>D 562</option>
                <option  value="D 581" <cfif council IS "#getdata.council#"> selected</cfif>>D 581</option>
                <option  value="D 583" <cfif council IS "#getdata.council#"> selected</cfif>>D 583</option>
                <option  value="D 597" <cfif council IS "#getdata.council#"> selected</cfif>>D 597</option>
                <option  value="D 598" <cfif council IS "#getdata.council#"> selected</cfif>>D 598</option>
                <option  value="D 599" <cfif council IS "#getdata.council#"> selected</cfif>>D 599</option>
                <option  value="D 628" <cfif council IS "#getdata.council#"> selected</cfif>>D 628</option>
                <option  value="D 686" <cfif council IS "#getdata.council#"> selected</cfif>>D 686</option>
                <option  value="D 698" <cfif council IS "#getdata.council#"> selected</cfif>>D 698</option>
                <option  value="D 848" <cfif council IS "#getdata.council#"> selected</cfif>>D 848</option>
                <option  value="D 862" <cfif council IS "#getdata.council#"> selected</cfif>>D 862</option>
                <option  value="D 870" <cfif council IS "#getdata.council#"> selected</cfif>>D 870</option>

</cfoutput>               
            </select>

i dont know where i am making mistake and i observered one behavoir that if i have less options it is working but not with many why like that , please help me in this

Thanks