将几个MySQL结果合并为一个JSON编码（PHP）

Question

Here is code as exists now:

while($row=mysql_fetch_assoc($count_query_result))
    $output[]=$row;
while($row=mysql_fetch_assoc($average_query_result))
    $output2[]=$row;
while($row=mysql_fetch_assoc($items_query_result))
    $output3[]=$row;

print(json_encode(array($output,$output2,$output3)));
mysql_close();

My question:

How do I take a single column from each of the three query results, and make a JSON array out of it, like so:

[{ 'att1' : 'data'}, { 'att2' : 'data'}, { 'att3' : 'data'}]

ASSUMING:

• att1 came from the $count_query_result/$output
• att2 came from the $average_query_result/$output2
• att3 came from the $items_query_result/$output3

Therefore, encoding only one variable, not 3.

Answer 1

$result = array('att1' => $row['data'],
                'att2' => $row['data']

echo json_encode($result)

where $row['data'] is the information that you want returned from each of your queries