RE: [PHP-DB] URGET HELP : Logic Help - for first record do_this for each record after do_that

[Hutchins, Richard]

What about wrapping your logic in a counter? Set $count=1,
if($count=1){do_this; then $count++;} else{do_that}. Wouldn't really add any
overhead to your script since the counter only gets incremented once when
the if() statement is true then stays at 2 and executes the else{} stuff
after that.

Pretty stupid solution and maybe not the most elegant, but you DID say
URGENT.

I just read Paul's post. This is pretty similar.

> -Original Message-
> From: Aaron Wolski [mailto:aaronjw@;martekbiz.com]
> Sent: Friday, October 25, 2002 2:54 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] URGET HELP : Logic Help - for first record 
> do_this for
> each record after do_that 
> 
> 
> 
> 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: [EMAIL PROTECTED]
> > 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: 
> > 
> > 
> > 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
> 
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] URGET HELP : Logic Help - for first record do_this for each record after do_that

[Jason Wong]

On Saturday 26 October 2002 02:53, Aaron Wolski wrote:

First, don't be so * lazy! You hijack an existing thread by replying to an 
existing post instead of starting a new one. AND you leave the original post 
hanging off the end of your message.

> 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?

Using mysql as an example:

if ($row = mysql_fetch_row($result)) {
  // do stuff for first row
}

while ($row = mysql_fetch_row($result)) {
  // do stuff for remaining rows
}

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *


/*
When you get your PH.D. will you get able to work at BURGER KING?
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php