Forums / Cotonti / Development / Help request :: JSON

$sql = sed_sql_query("SOME QUERY");
//echo json_encode($sql); this returns a resource id # because thats what it is a referrence for the results basicly

while($row = sed_sql_fetcharray($sql))
{
  //echo json_encode($row);
  //This would output the data for a row, but yes would not work for multiple rows however you could do this
  $json_data[] = $row;
}
echo json_encode($json_data);
//This would create an array and output it for each sql row such as data.0.sqldata