数据库输出json格式数据

[煎饼果子加仨蛋]

从数据库里输出接送格式数据，现在输出结果是这样的{"0":"2","fid":"2","1":"1","fup":"1","2":"forum","type":"forum","3":"默认版块","name":"默认版块"}
我想让他输出这样的{"fid":"2","fup":"1","type":"forum","name":"默认板块"}。
我写的代码
$sql = "select * from pre_forum_forum where fid = ".$fid."";
$result = mysql_query($sql);
while ($data=mysql_fetch_array($result)) {
echo json_encode($data,JSON_UNESCAPED_UNICODE);
}
而且我需要的是指取（fid和 name这两个字段的数据，求助

[justS0]

select fid,fup,type,name from pre_forum_forum where fid = ".$fid."

[justS0]

select fid,,name from pre_forum_forum where fid = ".$fid."

[煎饼果子加仨蛋]

引用 2 楼 justS0 的回复:

select fid,,name from pre_forum_forum where fid = ".$fid."

我现在输出的是这样{"0":"2","fid":"2","1":"默认版块","name":"默认版块"}而我的数据库里是没有{"0":"2","1":"默认版块"}这两个字段的，然后输出有这个，数据库大概是 fid name 2 默认板块

[智商众筹]

mysql_fetch_array改成mysql_fetch_assoc

[煎饼果子加仨蛋]

引用 4 楼 wander_wind 的回复:

mysql_fetch_array改成mysql_fetch_assoc

非常感谢，

[xuzuning]

mysql_fetch_array($result) 改成 mysql_fetch_assoc($result)