I am trying to print a table where the first set of columns are a single row.
The last column will display 2 results separated by a
…
Example
chapter, address, city, st, officer1
officer2
officer3
I have 2 tables one that contains the officers and one the chapter names and addresses - linked together by chapter number $num
I have tried several foreach’s and do while’s without any luck.
[php]
print “
Chapter | Name | City | Stated | Officers | $num | $chapter | $city | $meeting | $name |
---|---|---|---|---|
[/php]
The results I get are:
chapter1, address, city, state, officer1
chapter1, address, city, state, officer2
chapter1, address, city, state, officer3
chapter2, address, city, state, officer1
chapter2, address, city, state, officer2
etc…
what i want is:
Chapter1, address, city, state, officer1
officer2
officer3
Chapter2, address, city, state, officer1
officer2
officer3
etc…
Any help would be much appreciated…