I have a table containing people's photos ordered by their last names. Each row has 6 columns. The first column contains the initials of the people displayed on the same row. The rest of the 5 columns are the photos ordered by last name. I use a while loop to pull out the photos from database, but if there are more than one initials, like A,B,C in a row instead of only A, or only B. How could I display them all in one cell when using "while( odbc_fetch_row( $cur ) )"? But in the resultset, a row is for only one people. like:
people1 name1 email1
people2 name2 email2
people3 name3 email3
example:
initials people1 people2 people3 people4
A Adam Alex Apple Bond
B
C Candy Cat Couch CPP