Checkbox and MySQL's ENUM field

[Rio]

Hi there,

I have a checkboxs like the one below in my form page, to be used with MySQL fields set to ENUM('Y','N') NOT NULL DEFAULT 'N'.

<input name="$name" type="checkbox" value="Y" />

When it's checked it my PHP script happily insert "Y" (please ignore the brackets) into MySQL but otherwise the field is left blank. Does anyone know why?

Rio

[frezno]

If a checkbox is not activated (checked) it does not pass a value (as if it would not exist), so only if it's checked you get a value (Y in your case).

[Rio]

Even when the default value is set 'N' ?

That's being the case, do I have to tweak my PHP script to set the value of $name to 'N' ?

[frezno]

The field should stay at N as long as no other value is submitted. Once it was Y it doesn't change to N again.

For doing this, you need a little PHP scripting.
Here's an excerpt from my script:

/**
* If variable is set, set it to the set_checked otherwise set it to the
* unset_checked. Used to handle checkboxes when you are expecting them from
* a form.
*/
function check_checked(&$var, $set_checked = 1, $unset_checked = 0)
{
if (empty($var))
{
$var = $unset_checked;
}
else
{
$var = $set_checked;
}
}


function updateNewsletter($frm)
{
check_checked($frm['n_deleted']);

$sql = db_query("UPDATE ". DB_PREFIX ."newsletter
SET n_title = '$frm[n_title]',
n_description = '$frm[n_description]',
n_deleted = '$frm[n_deleted]',
n_modified = NOW()
WHERE n_id = '$frm[n_id]'
" );
} 

Although i use 1 and 0 as value instead of Y and N

EDIT:
Forgot to mention that i don't use ENUM's but bitfield (TINYINT or INT) for 0 or 1. Might make things easier for you.