Hello All --
I need some help with this.
I am trying to write a PHP page that generates a table with numerous rows and columns. I have stored all column and row entries in MYSQL and can retrieve and display them.
My problem is that every cell can potentially have multiple links to PDF files. I have resultsets set up now that is retrieving results for entire rows. Within this resultset, I have a field referencing a column name. There can be multiple instances of this in this resultset. I need to be able to group the records that match colmumn name and print those out in that cell.
Example: Say I have a table with rows a, b and c and columns d, e, and f.
I have three resultsets that retrieve all records for each given row:
This retrieves all my records for each of those rows. I have multiple records in each that refer to the columns. Say for example, 2 references for d, 3 for e and 4 for f.
select * from table where row='a'
select * from table where row='b'
select * from table where row='c'
So my question is, how can I loop through each of my resultsets so 2 entries print out in column d, 3 in e and 4 in column f?
I appreciate any guidance you guys could provide.