I want to make a form were someone can update multiple fields at once by selecting the rows with a check box then typing in on the next screen what they wanted added. But here is a trick I wan the old info to still be there I just want the new info to add a comma, a space, and then what they added. I got it to work with just one row but I don't know how to write it with multiple rows.
What I need to know is what I put in the name and value fields.
[Php]
<input type="checkbox" name="??" value="??"></p>
<input type="checkbox" name="??" value="??"></p>
<input type="checkbox" name="??" value="??"></p>
[/code]
This is the code that I used to add the comma, space, user input to the original. Not sure how to edit it to work with multiple entries.
function myvalue()
{
global $original, $add;
global $changing;
$changing = $original.", ".$add;
}
This is the command I used to enter the info. As you can see I use the timeid column to tell where to place the info.
mysql_query("UPDATE $table SET builders='$changing' WHERE timeid='$were'") or die ("Couldn't Execute Query.");