Graeme,
first, extend the for loop over the "if" and the query for insertion of
data. As you have it now, it just inserts the last element of the array.
second, I think that the for loop should be $a<$number. if you put <=,
then the loop is processing the array with the last value not assigned by
you (an extra element in the array).
Hope it helps.
Mihai
On Fri, 25 Oct 2002, Graeme McLaren wrote:
> 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
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
