Re: Nested loops help please?

Thanks for the suggestion. Would you be able to offer some code for
consideration? I tried something like this at one point but couldn't
get it to work.

Thanks,

Tzuriel
frothpoker wrote:
two queries would be easier but obviously has a bigger overhead.

You could do the following:

Set $CurrentYear as the yearID from the first row

on each time through the loop, check YearID against $CurrentYear and if
it is not the same then end the table and start a new one before
setting $CurrentYear to the yearID of the current row.




.

Relevant Pages

  • Re: Nested loops help please?
    ... Obviously you will need to output table headers before the first record ... Set $CurrentYear as the yearID from the first row ...
    (comp.lang.php)
  • Re: Nested loops help please?
    ... Set $CurrentYear as the yearID from the first row ... I have two tables, members and casts. ... columns Cast Member and Season. ...
    (comp.lang.php)