URGET HELP : Logic Help - for first record do_this for each record after do_that

From: Date: Fri, 25 Oct 2002 18:53:40 +0000
Subject: URGET HELP : Logic Help - for first record do_this for each record after do_that
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-22703@lists.php.net to get a copy of this message
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: [PHP-DB] 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 > >

« previous php.db (#22703) next »