Re: I'm having a blond moment with a while loop???

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



George Pitcher wrote:
Hi guys,

I'm doing something dumb but I can't see it.

The basic premise is:

sql search of orders sorted by customer
set g_customer_id to ''
loop through resultset
  if customer_id not same as last record's customer_id (g_customer_id)
    get customer email details
    set up message header if this is the first record for a customer
    set item details
  else
    set item details
    set g_customer_id to customer_id
  endif
  send email
end loop

Should not be line "set g_customer_id to customer_id" be in the "if" part? It's certainly useless in the "else" part as it's already equal to customer_id ;)



The problem is that as a sample I have two records from one demo customer (me) and I can only get my email to handle one record - either sending separate records for each record or one email covering the last record only

Its as if I should have another inner loop

Any tips

MTIA

George


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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux