[RESOLVED] More checkbox help

[ffsja]

Argh! No matter what I do I cannot get the value of the checkbox to stick. I'm trying to create a data entry and update form(s) that allow the user to select a checkbox specifying if the record is ready for enrollment. When I go to modify the values I cannot get the checkbox to 'stick' if it was already checked and updated as checked. The next time I open the record it is still unchecked.

I've also tried changing it and had it work the other way around so that it is checked no matter what.

How do I get it so the checkbox is checked if it was saved as checked and unchecked if saved as unchecked?

Here's the code I'm using in the actual form itself:

<? if ('$ready_for_enrollment' == 1) {
echo "<input type=\"checkbox\" name=\"ready_for_enrollment\" id=\"ready_for_enrollment\" value=\"1\" checked>";
} else {
echo "<input type=\"checkbox\" name=\"ready_for_enrollment\" id=\"ready_for_enrollment\" value=\"0\">";
}?>

Why isn't this working?

Thanks,
S./

[devinemke]

echo '<input type="checkbox" name="ready_for_enrollment" id="ready_for_enrollment" value="1"';
if ($ready_for_enrollment == 1) {echo ' checked';}
echo '>';

[ffsja]

Ok, I put in that exact code:

<? echo '<input type="checkbox" name="ready_for_enrollment" id="ready_for_enrollment" value="1"';
if ($ready_for_enrollment == 1) echo ' checked';
echo '>'; ?>

But it still doesn't keep it checked after I update it.

Thanks,
S./

[devinemke]

what is the exact data structure of your table? how are you setting the $ready_for_enrollment variable?

[ffsja]

The ready_for_enrollment is a smallint(4) data type in the mysql db. It doesn't have any other special qualities.

I'm setting the ready_for_enrollment variable using a while loop like so:

while ($row = mysql_fetch_array($result)) {
...various fields...
$ubd3_notes = $row['ubd3_notes'];
$ready_for_enrollment = $row['ready_for_enrollment'];
}

S./

[ffsja]

Ok - finally got it to stick.

Thanks for your help,
S./