PHP MYSQL ARRAYS PARENT CHILD
Posted on 2011-02-21
I have 2 data sets coming from MYSQL results:
ds1. Each row is a day of a given month: 2011-02/21
ds2. Each row is a report generated on a day within the given month.. each report has a designation: RR, CC, AG etc.
What I'm trying to do is generate an <li> list of each day in the given month, put the reports found in a title tag (RR, CC, AG etc) and a condition:
condition 1: foreach day in ds1, if the matching date in ds2 contains these reports (RR, CC) then display this...
condition 2: else if the matching date in ds2 contains these reports (AG) then display this...
condition 3: else display...
DS1 and DS2 are not the same length obviously and DS 2 may not include all the dates in DS1... but I need to display all the dates in DS1.. heres a sample of the data:
DS2: $row['fdate'], $row['freport']
Hope that helps, thanks in advance.