title: Get single database row with PHP
body: <p>This sounds daft and easy but I'm not 100% sure here.</p>
  
  <p>I have this code:</p>
  
  <pre><code>$query = $this-&gt;db-&gt;query("MY QUERY");
  </code></pre>
  
  <p>The query will result in one row and I basically want to get the column called "id" from that single row so I can echo something like $query->db->row->id..</p>
  
  <p>How do I do this?</p>