Checkbox - showing original values for update

[jarow]

I have an update form which displays the orginal values of the record being updated, i.e. it displays all the TEXT fields. I cannot get it to disply the original values of the checkboxes - either checked or unchecked.

I have looked around in the forums but can't find an answer. This one seems the most promising but can't get it to work.

$checked=$row_rsupdate2['checkbox'];
echo "<input type='checkbox' name='AN'";
if ($checked==1){ 
echo " CHECKED>"; 
}else{ 
echo ">"; 
} ?>

The checkbox values in my database are 1 or 0. The value of the checkboxes on the original add record form was "checkbox"

any ideas on how I might show the original checkbox values on the update form?

many thanks

Jim

[bad76]

Hi,
may be you forget "value" tag.
Try this:

$checked=$row_rsupdate2['checkbox'];
echo "<input type='checkbox' [B]value="1"[/B] name='AN'";
if ($checked==1){ 
echo " CHECKED>"; 
}else{ 
echo ">"; 
} ?>

Also try to debug out every $checked variable.