echo json_encode($row) returns duplicate values

here’s my php code

$result = mysql_query("select * from backup where owner='$email'") or die (mysql_error());
$dataCount = mysql_num_rows($result);
$row = mysql_fetch_array($result);
echo json_encode($row);

and it returns this:

{"0":"1","id":"1","1":"2015","year":"2015","2":"55","necessities":"55","3":"10","savings":"10","4":"10","entertainment":"10"}

this is how jsonviewer.stack.hu shows it
jsonviewer

fyi, there’s only one row of data inside the table. but it seems json_encode($row) displays the value twice, but firstly using number (0 – 4) as the label, then it uses the column name (id, year, necessities, savings, entertainment) as the label.

how can I make it to display the value only once, using the column name?


Source: json

Leave a Reply