need help with checkboxes

kaos057

I am trying to make a form for a user profile where checkbox values are stored in a database, and then when the profile is updated the values are returned. The problem is I cant get the values to store in the database. All the rest of the stuff gets stored just not the checkbox. Here is the code I have been trying...

<?php

?><input type="checkbox" name="epic" value="<?php echo $myrow["epic"] ?>"

<?php

if ($myrow[epic] == "1") // IF THE CHECKBOX IS CHECKED 
{ 
    ?>checked="checked">
    <?
} 
else // IF THE CHECKBOX IS NOT CHECKED
{
    ?>>
    <?
}

I also have the field set as TINYINT. Is there a different way to do this or does anyone know what is wrong with the code?

swallace

Hi koas057,

It think your problem is with the HTML for checkboxes.

you don't need checked=checked, just the word itself.
Good luck

suntra

Originally posted by swallace
<INPUT TYPE="checkbox" NAME="epic" <?php if ($myrow[epic] == "1") echo CHECKED ?> >

A little correction :

Always put quotes with an array key (maybe you don't see errors because you set error_display to off), and I don't think CHECKED is a defined constant, so use quotes to print it. Also, if $myrow["epic"] !=1, you would get something like :

There is a space at the end... not very nice ! That's why there is a space in the echo statement, but no more space between NAME="epic" and <?php.