Predifining variables

[Anon]

I am in the process of designing a login page/registration page for my site, and there is one lasting question that I have not been able to figure out.

I have a column in my MySQL db, lets call it u_ispr, the default for this column is "n" and it is set to char(1). This corresponds to a checkbox, and if the box is checked, the value then becomes "y". However, if you submit the form, what I am getting is the value becomes "" (null).

Is there an if statement that I can use that says if $u_ispr = "y" etc.... then continue with form submition kinda thing? Could someone forward me a snippet of source sitting around if they have one?

Cheers,

Sean

[Anon]

Hi,

A selected checkbox returns value "on", an unselected one returns.. nothing (empty).

So.. to update your db field accordingly, you should use:

if ( $u_ispr ) {
[ set value to "y" ]
} else {
[ set value to "n" ]
}

assuming $u_ispr is your checkbox on the form.