Mihail, thanx for your advice, I've got it going now ! :) Thank you !
Richard, your points were valid, the HTML code with the slashes was just a
copy n' paste from a PHP script and the comma I think I deleted by accident
so its all sorted now.
Thank you again!
Graeme :)
----- Original Message -----
From: "Mihail Bota" <mbota@almaak.usc.edu>
To: "Graeme McLaren" <mickel@ntlworld.com>
Cc: <php-db@lists.php.net>
Sent: Friday, October 25, 2002 7:47 PM
Subject: Re: Inserting checkbox data
> 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
