Update multiple database entries

[jbachris]

I want to make a quick to-do list script. I can handle entering the info, etc.

What I have a question about is when I go and view the list of to-do items, once they are complete, I want to be able to mark them "Done"

So I'd have a list of all the items and a checkbox for each item. If 3 of 10 are done, I'd select the checkbox for those three, click the submit button and I'd like it to update one field for each entry.

So, I'd have todo_ID, todo_DONE and want to UPDATE todo_list SET todo_DONE = 1 WHERE todo_ID = '".mysql_real_escape_string($_POST['todo_ID'])."'

My question is how can I do this for multiple entries all at once?

[bubblenut]

You can use OR or IN
First, OR

$sql = "UPDATE todo_list SET todo_DONE=1 WHERE todo_ID='".mysql_real_escape_string( $_POST['todo_ID1']) . "' OR todo_ID='" . mysql_real_escape_string($_POST['todo_ID2']) . "'";

and using IN

$sql = "UPDATE todo_list SET todo_DONE=1 WHERE todo_ID IN ('".mysql_real_escape_string( $_POST['todo_ID1']) . "', '" . mysql_real_escape_string($_POST['todo_ID2']) . "')";

Hope this helps.
Rob