Checkboxes Problem

[Anon]

I'm having trouble figuring out how to write this code. Here's what I've got: A database full of names, address, etc. There is one column in the DB that is always going to be "yes" or "no". What I want to do is load a page with all the names that have a "no" in that column, then put a checkbox beside the name. The user would click the boxes of the people he wanted to switch from "no" to "yes". Then hit submit. And the program would update the DB.

I'm using a while loop to pull out the names of the "no" people and display them with a checkbox. What I can't figure out is how to pass the checkbox data to the program that updates the DB. What can I put in for the "name=" part of the checkbox form? Ideally, I'd like to somehow pass an array that contains the index number of the entries to be changed. Then I can just run a while loop on the array in the updating portion of the program. I don't know if there's a way to do this though.

Any ideas?

Cj

[Anon]

Something like name=makeyes[] value=(id field from your db)

The your processing script you will have an array named $makeyes

You could do seomthing like:

while (list ($key, $val) = each ($makeyes)) {

Run your query here like:

$sql = "UPDATE TABLE SET yesnofield='yes' WHERE ID = '$val'";
$result = mysql_query($sql, $db);
$mysql_free_result($result);

 }

[Anon]

Works like a dream! Cheers.

Got rid a whole page of code with nasty whiles and ifs with this little snippet of yours.

[Anon]

Wow... thanx a lot it helped me too...

[Anon]

But u cannot work with JavaScipt anymore, because JS dont unterstand the [] behind the formelement name. I Need it to enable or disalble multiple Checkboxes oder Select lists via js. ;-(