checkboxes and update query

[hmlarson]

I have a form/table with checkboxes that I would like the user to
check / uncheck if they want a certain record to display in a gallery
on a website. I'm having problems figuring out how to construct the
update query so that it picks up when a user checks/unchecks the
checkbox and updates the db w/ the matching record ID#.

Right now, if a user unchecks a box, the value does not get passed
and the DB does not update - set/change it to 0. The only values that
get passed are the checkboxes that are checked and these end up being
mismatched with the matching id (passed in a hidden field).

The checkboxes look like this:

<?
while ($displayletter = mysql_fetch_arr ay($result)) {
echo '<tr>' .
'<td>' . $displayletter['letter_id'] . '</td>' .
'<td><a href=display_le tter.php?letter _id=' .
$displayletter['letter_id'] . ' target=blank' .
$displayletter['letter_title'] . '</td>' .
'<td>' . $displayletter['submit_date'] . '</td>' .
'<td>' . $displayletter['response_date'] . '</td>';
if ($displayletter['letter_gallery '] == "1") {
echo '<td align="center"> <input type=checkbox name="publish[]"
value="1" CHECKED><input type=hidden name="update_id[]" value="' .
$displayletter['letter_id'] . '" ></td>' ;} i

f ($displayletter['letter_gallery '] == "0") {
echo '<td align="center"> <input type=checkbox UNCHECKED
name="publish[]" value="0"><inpu t type=hidden name="update_id[]"
value="' . $displayletter['letter_id'] . '" ></td>' ; }
echo '</tr>';
}
} else { //display error message if something wrong
echo '<p>' . mysql_error() . '<p>';
}
?>
</table>
<p>
<input type="hidden" name="submitted " value="TRUE" />
<input type="image" src="../images/80x30_submit.gi f" name="image"
width="80" height="30" />
</p>

</form>
and my update query....

$update_id = $_POST['update_id'];
$publish = $_POST['publish'];

if (isset($_POST['submitted'])) {
if (isset($_POST['update_id'])) {

for($i=0;$i<$co unt;$i++){
$updatequery = "UPDATE Letters SET letter_gallery= '$publish[$i]'
WHERE letter_id='$upd ate_id[$i]'";

if ( !$result1 = mysql_query($up datequery) ) {
echo $updatequery;
die("<p class=alert>Cou ld not save the record!<br />ID: $id</
p>");

} else {
echo implode($publis h);
echo $updatequery;
// echo "<meta http-equiv=\"refresh \" content=
\"0;URL=publish _letter.php\">" ;
echo "<p class=alert>Rec ords updated. </p>";

}

}}}

Any help you can provide is MUCH appreciated!!

[Jerry Stuckle]

hmlarson wrote:

I have a form/table with checkboxes that I would like the user to
check / uncheck if they want a certain record to display in a gallery
on a website. I'm having problems figuring out how to construct the
update query so that it picks up when a user checks/unchecks the
checkbox and updates the db w/ the matching record ID#.

Right now, if a user unchecks a box, the value does not get passed
and the DB does not update - set/change it to 0. The only values that
get passed are the checkboxes that are checked and these end up being
mismatched with the matching id (passed in a hidden field).

The checkboxes look like this:

<?
while ($displayletter = mysql_fetch_arr ay($result)) {
echo '<tr>' .
'<td>' . $displayletter['letter_id'] . '</td>' .
'<td><a href=display_le tter.php?letter _id=' .
$displayletter['letter_id'] . ' target=blank' .
$displayletter['letter_title'] . '</td>' .
'<td>' . $displayletter['submit_date'] . '</td>' .
'<td>' . $displayletter['response_date'] . '</td>';
if ($displayletter['letter_gallery '] == "1") {
echo '<td align="center"> <input type=checkbox name="publish[]"
value="1" CHECKED><input type=hidden name="update_id[]" value="' .
$displayletter['letter_id'] . '" ></td>' ;} i

f ($displayletter['letter_gallery '] == "0") {
echo '<td align="center"> <input type=checkbox UNCHECKED
name="publish[]" value="0"><inpu t type=hidden name="update_id[]"
value="' . $displayletter['letter_id'] . '" ></td>' ; }
echo '</tr>';
}
} else { //display error message if something wrong
echo '<p>' . mysql_error() . '<p>';
}
?>
</table>
<p>
<input type="hidden" name="submitted " value="TRUE" />
<input type="image" src="../images/80x30_submit.gi f" name="image"
width="80" height="30" />
</p>

</form>
and my update query....

$update_id = $_POST['update_id'];
$publish = $_POST['publish'];

if (isset($_POST['submitted'])) {
if (isset($_POST['update_id'])) {

for($i=0;$i<$co unt;$i++){
$updatequery = "UPDATE Letters SET letter_gallery= '$publish[$i]'
WHERE letter_id='$upd ate_id[$i]'";

if ( !$result1 = mysql_query($up datequery) ) {
echo $updatequery;
die("<p class=alert>Cou ld not save the record!<br />ID: $id</
p>");

} else {
echo implode($publis h);
echo $updatequery;
// echo "<meta http-equiv=\"refresh \" content=
\"0;URL=publish _letter.php\">" ;
echo "<p class=alert>Rec ords updated. </p>";

}

}}}

Any help you can provide is MUCH appreciated!!

Yes, the mismatch is a problem with checkboxes - which is why you can't
use just update_id[] with them.

What you need to do is give each checkbox a unique id - maybe something
like update_id[$display_letter['letter_id']. Then have a hidden field
in each one such as

<input type=hidden name="recid[]" value="$display _letter['letter_id']>

The hidden field will allow you to track each record displayed (I'm
assuming $display_letter['letter_id'] is a unique id). Then you can
check to see if your checkbox is checked by testing the appropriate
update_id array element.
--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===