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