Hey guys,
Not really off topic as this involves some Db work as I have to query
the DB.
Got a logic problem that was jumped dumped on me from UPS (dummys!).
Basically I need to pull some records out of a database and for the
first record do_this logic and for each record after in the array
do_something_else logic.
How would I approach this?
something like:
for ($first_record) {
do_something;
} else {
do_something_else;
}
Any clues?
Thanks!
Aaron
> -----Original Message-----
> From: Graeme McLaren [mailto:mickel@ntlworld.com]
> Sent: Friday, October 25, 2002 2:40 PM
> To: php-db@lists.php.net
> Subject: Inserting checkbox data
>
>
> 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
