MySQL Database Update

[mjstehn]

I have a MySQL table that I want to display several records from. I want to have a checkbox to check or uncheck activity of each record. How do I go about updating each record when they submit the changes? It seems to be just updating the last record. Can someone give me an example of how to do this if possible. Thanks,

Mike

[tomkleijkers]

Is this your question:

You want to use checkboxes to select the records you want to view?

So if I check 1,3,5,23 I'll get the results of record 1,3,5 and 23? Or do I understand your question wrong?

[jasper]

You need some dynamic code to check all checkboxes. First you create a form with checkboxes with the name containing the databaseID, say "id_354". The parser checks all posted variables from your from and finds the used ID with a regular expression. If the checbox is set, then do some database update for that specific ID. In pseudocode:

The form to show all records with a checkbox:
while( $dbresult ) {
echo "<input type=checkbox name=id_".$id." value=Y>";
}

The parser:
<?php
foreach( $HTTP_POST_VARS as $key=>$val )
{
// Do they match our variable prefix?
if( ereg( "id_([0-9]+)", $key, $regs ) )
{
$posted_id = $regs[1];
$posted_checkbox_value = $val;
if( $posted_checkbox_value == "Y" ) {
$sql = "UPDATE table SET active='Y' WHERE id='$posted_id'";
$result = mysql_query( $sql, $conn );
}
}
?>

[knelson]

If I understand the question, it seems that you are asking about how to update multiple rows with a single submit...perhaps based on the checkbox criteria?

A while back I searched this forum for "multi-row inserts" and found several useful threads. I believe you'll need a combination of this information and the suggestions mentioned here to achieve your results..

hope this was what you're after..

[mjstehn]

Jasper,

I tried your code an it worked. I appreciate your help. One other questions though. What if I want to update the database if they uncheck a checked field also? I tried messing with your code, but I can't seem to get it to take. Any help you can give would be appreciated.

Thanks,

[gljaber]

Another way to do this is to do this in the input tag:

<INPUT TYPE="checkbox" NAME="ID[]" VALUE="$id">

then in the page that you post to, you get an array $ID that contains all the values that were checked!

glj