[PHP-WIN] Matching arrays to build tables (Solved)

2003-09-29 Thread Mike Quinn
I got a very modest email from Bill Baron with the following code which works absolutely perfectly even though Bill never tested it! (Slick!). Thank's a million for that Bill and also thanks to Svensson for all the help - very much appreciated. Here is the code which I modified ever so slightly to

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
om: Mike Quinn > To: [EMAIL PROTECTED] > Sent: 29-9-2003 6:30 > Subject: [PHP-WIN] Matching arrays to build tables > > Hi, > > I have 3 dynamic arrays which is related data pulled from a mySQL > database, > the first being day $days[],second being amount $amount[] and t

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

[PHP-WIN] Matching arrays to build tables

2003-09-29 Thread Mike Quinn
Hi, I have 3 dynamic arrays which is related data pulled from a mySQL database, the first being day $days[],second being amount $amount[] and third being a specific code $code[]. What I need to do is display a table with 1 to 15 in the left hand column (days) but where the array $days[] contains a