Sorry, Me again (PHP)

[Django x2]

Ok, apart from my other issues, here's another one which I seem incapable of solving.

My form has a checkbox (now, nicely formatted thanks to Skyfall, etc).

When the form is submitted and the data passed to the DB, I want the DB to show a zero if its left unchecked, or a 1 if its checked.

This easy enough to do? Or is there a better method?

Thanks

 

[Django x2]

Hmm, ok, how does that fit in with this which is the rest of my form?

<?php
} else {
$field1 = stripslashes(mysql_real_escape_string($_POST['field1']));
$field2 = stripslashes(mysql_real_escape_string($_POST['field2']));
$field3 = stripslashes(mysql_real_escape_string($_POST['field3']));

mysql_query("INSERT INTO table (field1, field2, field3) VALUES 

('$field1','$field2','$field3')");
echo "Thank you. You have successfully added <font color=#FF0000>$field1</font> to the database";
}
mysql_close();
?>

Thanks for the phpfreaks link too

 

[Django x2]

Don't be lazy

EDIT: doesn't seem to work. When ticked, MySQL reports it as an '0' and when left blank, MySQL reports it as an '0'

 

[Django x2]

you're stripslashing after escaping?!

Eh...?