Thanks GKWelding, you set me back on the right track. I was getting myself all confused. Here's the correct code for others:
$rs1 = query("SELECT DISTINCT groups.group_ID, group_settings.name FROM groups, group_settings WHERE group_settings.group_ID=groups.group_ID AND groups.group_ID IN (SELECT group_ID FROM groups WHERE user_ID=1)");
$c = 0; $glist = array();
while($row = mysql_fetch_array($rs1)){
$glist[$c] = array('id'=>$row['group_ID'],'name'=>$row['name']);
$c++;
}
$groups['list'] = $glist;
$groups['count'] = $c;
$rs2 = query("SELECT COUNT(c_ID) FROM contacts WHERE group_ID='$gid'");
$row2 = mysql_fetch_assoc($rs2);
$data['cCount'] = $row2['COUNT(c_ID)'];
$rs4 = query("SELECT fb_ID FROM users WHERE user_ID IN (SELECT user_ID FROM groups WHERE group_ID='$gid')");
$count = 0; $list = array();
while($row4 = mysql_fetch_array($rs4)){
$list[$count] = $row4['fb_ID'];
$count++;
}
$users = implode(',',$list);
$data['users'] = $users;
$data['fCount'] = $count-1; //offset for yourself
$data['appstoreID'] = '331786748';
$data['groups'] = $groups;
$output = json_encode($data);
echo $output;
Output:
{
"cCount":"0",
"users":"",
"fCount":-1,
"appstoreID":"331786748",
"groups":
{
"list":
[
{"id":"1","name":"Test Group"},
{"id":"2","name":"Ryan's Test Group"}
],
"count":2
}
}