On 5/8/05, George Pitcher <george.pitcher@xxxxxxxxxxx> 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 This looks fine to me. Although you might want to use an $i that gets incremented instead of the customer IDs. > 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 Not sure I understand what is going on......Could you post the code? It's kind of hard to troubleshoot code I can't see. However, I can offer this suggestion. Check your syntax. Make sure your loops have double equal signs, and be sure that the while loop has a way of moving on in the records. (I didn't see anything like that in the outline) Also, you might want to try adding some echo statements in at the various steps that output what is going to happen on the next line of code. That way you can see what it's doing, and how many times it's doing it. Even output the data in the table with a print_r to make sure the data PHP has is the data you want it to loop through. Adding output to troubleshoot your code is always a good thing to do. Take two of these and call me in the morning. That is, try this stuff, and if you can fix it, great. If not, reply WITH CODE POSTED and I'll be happy to tell you what I can, and I'm sure others will be too. -- disguised.jedi@xxxxxxxxx PHP rocks! "Knowledge is Power. Power Corrupts. Go to school, become evil" Disclaimer: Any disclaimer attached to this message may be ignored. However, I must say that the ENTIRE contents of this message are subject to other's criticism, corrections, and speculations. This message is Certified Virus Free -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
