How to Store Multiple Query in Array

how can i store my query results in this array ? that is my question

Yes, like bclinton advises, use

PHP Code:

//return $query->result();
return $query->result_array(); 


in your model. That will return an array that looks like this.

Code:

array
  0 => 
    array
      'id' => string 'sku_567ZYX' (length=10)
      'qty' => int 1
      'price' => float 9.95
      'name' => string 'Coffee Mug' (length=10)

Then you can add that array to $data array like this

PHP Code:

$data[] = $query[0]; 


You can try this test code to see that it works.

PHP Code:

<?php
  $data = array(
    array(
      'id'      => 'sku_123ABC',
      'qty'     => 1,
      'price'   => 39.95,
      'name'    => 'T-Shirt',
      'options' => array(
        'Size' => 'L',
        'Color' => 'Red')
    ),
    array(
      'id'      => 'sku_965QRS',
      'qty'     => 1,
      'price'   => 29.95,
      'name'    => 'Shot Glass'
    )
  );
  var_dump('original $data', $data);

  $query[0] = array(
    'id' => 'sku_567ZYX',
    'qty' => 1,
    'price' => 9.95,
    'name' => 'Coffee Mug'
  );
  var_dump('query array', $query);

  $data[] = $query[0];

  var_dump('final $data', $data);
?>