Help? Checkbox mania!

[Anon]

Hi,

I hope someone can help. What I am trying to do is this: I have a list of items in a Database. I want to display each of these items with a checkbox next to it. The user is expected to mark the box if they are 'done' with the item. When the form is submitted, I need to update the db with the 'done' items so that I will not bug the user with tasks they have already done.

example:
| | Task 1 - do this by x date

| | Task 2 - do this by x date

|x| Task 3 - do this by x date

|x| Task 4 - do this by x date

Upon submit, task 3 & 4 needs to be updated in the db as 'done'.

I have read through the manual, through this help forum, and nothing is working. Please help!

Thanks!!!

[lucianoes]

I guess you have to create an ENUM column called "done" in your table, with values 'YES' and 'NO', defaulting to 'NO'. When the variable corresponding to the checkbox is sent to the script, it UPDATEs the table and SETs the value to 'YES'.

    Luciano ES
    Santos, SP - Brasil