I am not sure I understand your problem or what it consist
of, but maybe you might like to do it like this then:
SELECT day, SUM(amount) AS amount_sum, DISTINCT(code) AS code
FROM <some tables>
WHERE <some conditions are true>
GROUP BY day, amount_sum, code
ORDER BY code, day
Displaying this result set should not be much of
a problem. In pseudo code it might look like this:
WHILE (not_end_of_result_set) {
@Itter = 0;
WHILE (still_a_certain_code_type && @Itter < 15) {
@Itter++;
IF ($day_number == $Itter ) {
Display_Sum_and_Code_in_HTML_Table();
}
ELSE {
// Skips this block if you don't want to display "empty" days
Display_Empty_Day_in_HTML_Table();
}
} // WHILE inner
} // WHILE outter
Or you can just make this a function and call
it for each code type... or whatever....
-----Original Message-----
From: Mike Quinn
To: php-windows@lists.php.net
Sent: 29-9-2003 7:18
Subject: Re: 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" <B.A.T.Svensson@lumc.nl> escribio en el mensaje
D291F33C586C8E48B95C26F8C805513A319B98@mail5.lumc.nl">news:D291F33C586C8E48B95C26F8C805513A319B98@mail5.lumc.nl...
> 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: php-windows@lists.php.net
> Sent: 29-9-2003 7:11
> Subject: Re: Matching arrays to build tables
>
> 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 beside
> the
> correct date of entry. I have no quams with SQL but with arrays in
PHP.
> I
> guess what I have to do is loop from 1 to 15 using $i to display all
of
> the
> days in left column, then within the loop check the value $i to see if
> it is
> equal to $days[] if it is then add the values for this day and pop it
> into a
> column beside the day and then the code next to this. I have tried
what
> I
> believe to be the best way to do this but have failed miserably as I
am
> crap
> with array manipulation.
>
> Thanks a mil for the SQL though,
>
> Michael
>
>
> "B.A.T. Svensson" <B.A.T.Svensson@lumc.nl> escribio en el mensaje
> D291F33C586C8E48B95C26F8C805513A319B94@mail5.lumc.nl">news:D291F33C586C8E48B95C26F8C805513A319B94@mail5.lumc.nl...
> > Would something like
> >
> > SELECT day, SUM(amount) AS amount_sum, DISTINCT(code) AS code
> > FROM <some tables>
> > WHERE <some conditions are true>
> > GROUP BY day,amount _sum, Code
> >
> > be usefull for you? Or do you already do this?
> >
> > -----Original Message-----
> > From: Mike Quinn
> > To: php-windows@lists.php.net
> > Sent: 29-9-2003 6:30
> > Subject: 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 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 an
> item
> > I
> > need to add a column with the related data but add the values of
> amount
> > if
> > there are two entries for a given day, something like the below.
> >
> > $days[] = ('2', '2', '5');
> > $amount[] = ('150', '100', '90');
> > $code[] = ('LAC', 'LAC', 'NCA');
> >
> > +++++++++++++
> > Day |Amt. | Code |
> > 1 | 0 | |
> > 2 | 250 | LAC |
> > 3 | 90 | NCA |
> > 4 | 0 | |
> >
> > etc. until 15!
> >
> > Any help would be greatly appreciated my code is getting jumbled and
> > confusing :(.
> >
> > Thanks
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
