Checkbox inputs value or NULL only

[maxwave]

Hi all!

I have a simple checkbox that returns a "1" or a "". I assume "" is a NULL character. How can I have the NULL returned as "0" instead, and what data type should the cloumn be if I enter 1 ands 0 using MySQL? bit?

<input type=checkbox name=single value="1">

$Query = "INSERT into $TableName values ('$_POST[single]')";

I'm testing by using:
print ("The query is:<BR>$Query<P>\n");

Thanks!

[cgraz]

if ($_POST['single'] == "") {
   $_POST['single'] = "0");
}
$Query = "INSERT into $TableName values ('$_POST[single]')"; 

Cgraz

[maxwave]

Thank you, Thank you, Thank you!!

You forgot a parenthesis '(' ; but I got it, thanks again!

[cgraz]

whoops 😉