Inserting checkbox data
| From: | Graeme McLaren | Date: | Fri, 25 Oct 2002 18:39:45 +0000 |
| Subject: | Inserting checkbox data | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22700@lists.php.net to get a copy of this message | ||
Hi all, I'm having a problem inserting a value from a checkbox into a MySQL DB. I can print
out what the variable holds, the problem is it just won't go into the DB. Weird thing is when
I login to SSH there isn't a NULL value for it instead that field is just blank.
Anyone got any ideas what the problem is?
The HTML that is used for the checkbox is:
Gift Wrapping: <input type=checkbox Name=GiftWrapping[] Value=\"Y\">
So it should theoretically insert "Y" into the DB
Here is the code that appears to be causing the problem:
$number=count($GiftWrapping);
for($a=0;$a<=$number;$a++)
{
echo $GiftWrapping[$a];
$GW = $GiftWrapping[$a];
echo $GW;
}
if ($Submit == "Submit") {
$sql = "INSERT INTO SiteMember SET
FirstName = '$FirstName',
LastName = '$LastName'
Username = '$Username',
Password = '$Password',
GiftWrapping = '$GW'";
}
Thank you in advance for any help.
Graeme :)
Public Sub House()
On Error Resume drink
If Pint.empty = True Then
Pint.refill
Else
Pint.drink
End if
stomach.add Pint
MsgBox " I've had .... " & stomach.count & " Pints"
MsgBox "VERY DRUNK"
End Sub