update mysql with select menu

[dizad]

Hi, I've searched all over for help with this. I have a select menu with three options, yes, no and pending. The "selected" option is from a query that grabs the field "status" from the database. If "status is pending, I would like to be able to change(update query) that to either yes or no from the select menu. Any ideas?

[A1ien51]

Um, not sure what the problem is. You submit the form with the data and your serverside page updates the SQL DB.

Eric

[dizad]

I'm not submitting a whole new form. I'll try to explain what I'm trying to accomplish. After a user has submitted a new recipe, the recipe has "pending" under the status field in the database. The admin reviews the recipe and selects "Yes" from the select menu. I guess I could submit all the info back into the db as an update query, but I'd like to update just the status field. I forgot to mention that the page with the NEW recipe also has the other recipes and their current status. So, I don't want to submit everything. The more I write here the more ideas come to mind. Maybe if I use "WHERE status = 'pending' in the update query.