Simple code - just not working

[tpiele]

I honestly cannot figure out why this code will not work. I have it on another form, another page and it works fine, different variables but the same code. Can someone point out my error?

Database field is called "BillMe" and is SmallInt, default zero, not null....

From Subscribe.php

 <form name="order" action="subscribe2.php" method="POST" onSubmit="return checkit(this)">

.
.
.

<td><INPUT TYPE="checkbox" NAME="Bill_Me" Value="on">&nbsp;Bill Me</td>

From subscribe2.php

$BillMe = $_POST['Bill_Me'];

if ($BillMe == "on") {
$BillThem = "1";
} else 
{
$BillThem = "0";
}

$subscribe = "INSERT INTO subs (BillMe) VALUES('$BillThem')";

I tried changing the declared value of the checkbox in the initial html form from "on" to "off" to "1" or"0" or leaving it out all together and tried switching the $BillThem value in the if statement to see if my logic was backwards but I just keep getting the fefault of "0" in every instance.

Any ideas? Am I just retarded or is it because it is 7am?

[TheDefender]

Probably the 7AM thing...

What happens if you hard code 1 into the insert query?

$subscribe = "INSERT INTO subs (BillMe) VALUES('1')";

My guess is that it will work fine. (assuming everything else is right).

If it works, try concatinating your string and see if that helps any...

$subscribe = "INSERT INTO subs (BillMe) VALUES('".$BillThem."')";

[tpiele]

I got it to work, I actually set the variable to "BillMe" or "DoNotBillMe" and it worked, I'm just retarded. i run a magazine now and do their web work on the side as well as work as an editor so my code skills are slippin haha.... thanks man.