mysql Boolean syntax?

Dolemite50

Hi,
I am building a login that has a checkbox for if people want to receive a newsletter. It sounds like I should use a boolean column for this and just set it to 1 if "newsletter_chkbox" is checked. How would I go about that? Do I actually tell it to be 1?
if(newsletter_chkbox){
$newsletter = 1
}

INSERT INTO profile newsletter = '$newsletter'

???

duerra

MySQL boolean isn't a true boolean. In short, yes. Set the value to 1

rachel2004

Originally posted by Dolemite50
It sounds like I should use a boolean column for this and just set it to 1 if "newsletter_chkbox" is checked.

I can see why you're asking, but if you think about it, why does the column have to be a boolean if you plan on using an integer? Use data type tinyint and set it to 1 if "yes, I want a newsletter", otherwise it should be a default value of 0 (meaning the user has not asked either way, or has specifically declined a subscription).

Dolemite50

Thanks alot. 🙂