[RESOLVED] multiple results with json

[rbradshaw]

hey,

how can i return multiple records from a database to an ajax application in json? this is the code im using at present but it only returns one record:

$r = mysqli_query($dbc, $q);

$records = json_encode(mysqli_fetch_object($r));

print($records);

thanks.

[rbradshaw]

i know the query returns more than one record.

[cahva]

You have to loop through the records and add it to array. Just like you would normally do when looping through resultset.

$res = mysqli_query($dbc, $q);
$arr = array();

while ($row = mysqli_fetch_assoc($res)) {
{
	$arr[] = $row;
}

$records = json_encode($arr);

[rbradshaw]

thanks alot :-)