PHP并将MySQL行封装到JSON数组中

百家第一

我正在玩一个留言簿/聊天室的想法，并且有一个包含三列的MySQL表设置：
: `5 e& l5 t: [/ Z- }1-id-主键自动递增
2-名称-字符串
3-注释-字符串
我对PHP的经验很少，但这是我为该操作汇总的内容：
. v2 l: z/ G" ^$result = mysql_query("SELECT * FROM guestbook");
4 O% C# B/ V: ]/ i$i = 0;
% I5 c6 q' b4 C! y  A8 Zwhile($row = mysql_fetch_array($result))
- j! C# F. r8 R5 G) Q  {
      //add the row to the $chat array at specific index of $i
      $chat[$i] = $row;
# j5 X) z8 q' T+ [: t. G4 @      $i += 1;
  }
$encode = json_encode($chat);
$ k' y- B2 w2 m# secho "$encode";
但是，此输出看起来很糟糕：
[{"0":"1","id":"1","1":"Justin ","name":"Justin ","2":"Comment 1","comment":"Comment 1"},
9 O$ [: x4 f; E8 l9 d: S{"0":"2","id":"2","1":"Justin ","name":"Justin ","2":"Another comment","comment":"Another comment"},
{"0":"3","id":"3","1":"Justin ","name":"Justin ","2":"Look at this comment!","comment":"Look at this comment!"},
3 X! f: C8 N- B- _* f" H) L{"0":"4","id":"4","1":"Justin ","name":"Justin ","2":"Ok I'm done talking","comment":"Ok I'm done talking"}]
我希望获得三个字段：ID，名称和注释，但看起来好像翻了一番。有人可以帮忙吗？
谢谢！
               
# c# R5 S% c( O; q2 o& L解决方案: