title: How to get your data from a select statement in Kohana?
body: <p>If I have this code (which is from their docs)</p>
  
  <pre><code>$query = DB::query(Database::SELECT, 'SELECT * FROM users WHERE username = :user');
  $query-&gt;param(':user', 'john');
  $query-&gt;execute();
  </code></pre>
  
  <p>How would I access the actual data returned from this?</p>
  
  <p>I am looking for an associate array containing <code>$array['username']</code> and whatever other columns are on the <code>users</code> table. </p>
  
  <p>I have tried:</p>
  
  <pre><code>#1
  echo $query-&gt;execute();
  #2
  $row = $query-&gt;execute();
  echo $row['username'];
  #3
  $query-&gt;fetch();
  </code></pre>
  
  <p>None of which work. What am I missing?</p>