add array element to row returned from sql query

Question

I want to add an additional value into an array before passing it to json_encode function, but I can't get the syntax right.

 $result = db_query($query);

  // $row is a database query result resource
  while ($row = db_fetch_object($result)) {

  $stack[]  = $row; 
                // I am trying to 'inject' array element here
  $stack[]['x']  = "test";  
 }

echo json_encode($stack); 

Answer 1

If it's an array you can directly add a value:

$row['x'] = 'test';
$stack[] = $row;

if it's an object you can add another property:

$row->x = 'test';
$stack[] = $row;

if you want to keep the object and the extra value separated:

$data = array($row, 'x' => 'test');
$stack[] = $data;

Answer 2

but this does work.

$stack[]  = $row;       
$row->x = 'test';

Answer 3

How about something like:

$row['x'] = 'test';
$stack = $row;