drop down menu problems

[mattotto]

Hi all

I could do with some advice, i have created a form which queries several tables and displays the output on the screen for the user to edit and submit and changes.

The problem i have is with a drop down form it queries a seperate table and the selection the user selects is inserted into the table.

The problem is if a value already exists in the table i have added some code to inform the user that the record exists "echo $blah already exists", but if they amend something else on the form and dont touch the drop down form the value 0 is inserted into the table the only way to keep the value the same is to once select the option from the drop down menu.

Thanks

[tomhath]

I can't follow what's going on from your description. Can you either pre-select the option that does not update the database, or use a hidden form and the onchange event to keep track of what's really been selected by the user?

[mattotto]

sorry for description not being clearer

Basically I cant get the form to change the default value if the a record already exists in the database.

The drop down starts with a blank option thats where i think it is getting the 0 value from

Have spent several hours but to no avail. 🙁