Append to $row for details_col

herbo4

Hi there, have a small problem; I'd like to append data, specifically the result of a mysql_query, to the end or the $row variable in the Outpus section of the code. Specifically, this table is showing a group as a single row, and I would like to expand the row to see the group's population. The mysql structure keeps groups in one table, and the members in another. Performing a left join produces one row per member of the group, and I'd like to have just one row showing the group, then to expand the detailed row to see its members and their fields. I can append simple values to the $row variable, as adding $row[member][] = 1 is just fine, but if I try to add a value based on a mysql query I return JSON formatting errors. What's more, I can't even commit a mysql_query, whether or not its result is assigned to a variable, without returning a JSON formatting error. Any help on this is greatly appreciated.