title: ParamQuery Data Display
body: <p>I am trying to implement ParamQuery an excel like plugin in php.I am trying to fetch the data from a php which generates json output.It is fetching properly but i want to display the datas within the div:grid_array in the specified format.Am not able to do that The fields are all coming blank.</p>
  
  <p>My json output code:data.php</p>
  
  <pre><code>&lt;?php
   $conn = mysql_connect('localhost','root','pass');
   if(!$conn){
    die('Mysql connection error '.mysql_error());
   }
  
   $db = mysql_select_db('pop',$conn);
   if(!$db){
    die('Database selection failed '.mysql_error());
   }
  
   $sql = 'SELECT *FROM items';
  
   $result = mysql_query($sql,$conn);
  
  
   $data = array();
   while($row = mysql_fetch_array($result)){
    $row_data = array(
     'id' =&gt; $row['Item_id'],
     'Product' =&gt; $row['Product'],
      'Brand' =&gt; $row['Brand'],
      'Model' =&gt; $row['Model']
     );
    array_push($data, $row_data);
   }
  
   echo json_encode($data);
  ?&gt;
  </code></pre>
  
  <p>my html file which should display the data:</p>
  
  <pre><code>&lt;html&gt;
  &lt;head&gt;
  
      &lt;link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.9.1/themes/base/jquery-ui.css" /&gt;
      &lt;script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"&gt;&lt;/script&gt;
      &lt;script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.9.1/jquery-ui.min.js"&gt;&lt;/script&gt;
  &lt;!--PQ Grid files--&gt;
      &lt;link rel="stylesheet" href="pqgrid.min.css" /&gt;
      &lt;script src="pqgrid.min.js"&gt;&lt;/script&gt;
  &lt;!--PQ Grid Office theme--&gt;
      &lt;link rel="stylesheet" href="themes/office/pqgrid.css" /&gt;
  
  &lt;script&gt;
     $(document).ready(function(){
     var url = 'data.php';
        $.getJSON(url, function(data) {
            $.each(data, function(index, data) {
              var obj = { width: 700, height: 400, title: "ParamQuery Grid Example",resizable:true,draggable:true };
          obj.colModel = [{ title: "Id", width: 100, dataType: "integer" },
          { title: "Product", width: 200, dataType: "string" },
          { title: "Brand", width: 150, dataType: "string" },
          { title: "Model", width: 150, dataType: "string"}];
          obj.dataModel = { data:data};
          $("#grid_array").pqGrid(obj);
  
      });
  
  
     });
                      });
  
  
  &lt;/script&gt;
  &lt;/head&gt;
  &lt;body&gt;
  
   &lt;div id="grid_array" style="margin:100px;"&gt;
  &lt;/div&gt;
  &lt;/body&gt;
  
  &lt;/html&gt;
  </code></pre>