RE: [PHP-WIN] Matching arrays to build tables

2003-09-29 Thread Svensson, B.A.T. (HKG)
CTED] Sent: 29-9-2003 7:18 Subject: Re: [PHP-WIN] Matching arrays to build tables Sorry, very well spotted and I should have said so before - the codes will be the same as they will be related to the same transaction. Thnks, Michael "B.A.T. Svensson" <[EMAIL PROTECTED]> escribio en

Re: [PHP-WIN] Matching arrays to build tables

2003-09-29 Thread Mike Quinn
ing a proper answer: > is it possible to have different codes on the very same day? > > -Original Message- > From: Mike Quinn > To: [EMAIL PROTECTED] > Sent: 29-9-2003 7:11 > Subject: Re: [PHP-WIN] Matching arrays to build tables > > Hi Svensson, > > Thanks fo

RE: [PHP-WIN] Matching arrays to build tables

2003-09-29 Thread Svensson, B.A.T. (HKG)
Just a question for the purpose of giving a proper answer: is it possible to have different codes on the very same day? -Original Message- From: Mike Quinn To: [EMAIL PROTECTED] Sent: 29-9-2003 7:11 Subject: Re: [PHP-WIN] Matching arrays to build tables Hi Svensson, Thanks for that

Re: [PHP-WIN] Matching arrays to build tables

2003-09-29 Thread Mike Quinn
Hi Svensson, Thanks for that. (I can certainly use that to get the values for the added amounts for me) but I wish for the table to be built with 15 days in the left hand column some of which will not contain entries but for the days that there are items I wish for the HTML table to display these

RE: [PHP-WIN] Matching arrays to build tables

2003-09-29 Thread Svensson, B.A.T. (HKG)
Would something like SELECT day, SUM(amount) AS amount_sum, DISTINCT(code) AS code FROM WHERE GROUP BY day,amount _sum, Code be usefull for you? Or do you already do this? -Original Message- From: Mike Quinn To: [EMAIL PROTECTED] Sent: 29-9-2003 6:30 Subject: [PHP-WIN] Matching arrays