title: mysqli Object returned instead of result
body: <p>I am running </p>
  
  <pre><code>$this-&gt;db-&gt;query("SELECT `id` FROM $table WHERE $table.id ='$product_id'");
  </code></pre>
  
  <p>that should return <code>92</code> but its returning the below why?</p>
  
  <blockquote>
    <p>object(CI_DB_mysqli_result)#150 (8) { ["conn_id"]=> object(mysqli)#16
    (18) { ["affected_rows"]=> int(1) ["client_info"]=> string(6) "5.5.30"
    ["client_version"]=> int(50530) ["connect_errno"]=> int(0)
    ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) ""
    ["field_count"]=> int(1) ["host_info"]=> string(25) "Localhost via
    UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=>
    string(10) "5.5.31-cll" ["server_version"]=> int(50531) ["stat"]=>
    string(150) "Uptime: 106781 Threads: 14 Questions: 30097132 Slow
    queries: 13 Opens: 1937675 Flush tables: 1 Open tables: 400 Queries
    per second avg: 281.858" ["sqlstate"]=> string(5) "00000"
    ["protocol_version"]=> int(10) ["thread_id"]=> int(373292)
    ["warning_count"]=> int(0) } ["result_id"]=> object(mysqli_result)#161
    (5) { ["current_field"]=> int(0) ["field_count"]=> int(1)
    ["lengths"]=> NULL ["num_rows"]=> int(1) ["type"]=> int(0) }
    ["result_array"]=> array(0) { } ["result_object"]=> array(0) { }
    ["custom_result_object"]=> array(0) { } ["current_row"]=> int(0)
    ["num_rows"]=> NULL ["row_data"]=> NULL}</p>
  </blockquote>