Report using array

Asked

Viewed 42 times

0

I have the following problem: I have a table that has 3 fields:

id(PK) id_(FK) dates 

1 1 01/01/2015
2 1 01/02/2015
3 2 01/01/2015
4 2 01/02/2015

Well, I have a standard report where I have to print as follows:

NUM(seq) Name(search of other table) data1 data2

1 José(FK-id->1) 01/01/2015 01/02/2015
2 João(FK-id->2) 01/01/2015 01/02/2015

Detail is that I have to print up to 18 dates next to each other. If there are more than 18 dates for the same game id for the bottom line, otherwise skip to the next id as above.

I’m wearing a array and I could only print one line underneath the other and repeat the name on all of them. How can I do this?

NOTE: The report is working, but printing one line below the other, I just need to show how it is described above.

php

  • Show the code you’ve already done so we can get an idea of this.

  • Which bank are you using?

1 answer

0

What you can do, is to loop this array, group by FK, then loop the already grouped array, in each returned item loop the dates and display in the report.

Browser other questions tagged php

You are not signed in. Login or sign up in order to post.