title: Running database function in controller..how do I transfer to Model?
body: <p>Okay, I have a function in my controller that works. However, I shouldn't be calling the database in the controller (as we all know). I normally can easily migrate information from a model into a controller, but I'm having a hard time with this one. I won't even share my model version...how would you write this to a model?</p>
  
  <pre><code>    $this -&gt; db -&gt; select('title, price, number_sites, number_entries, white_label'); 
      $query = $this -&gt; db -&gt; get('pricing', 3); // limit 3 rows
  
      $row1 = $query-&gt;row(0); // 0 grabs first row in table: Package 1        
      $data['row1'] = $row1;
  
      $row2 = $query-&gt;row(1); // 1 grabs second row in table: Package 2        
      $data['row2'] = $row2;
  
      $row3 = $query-&gt;row(2); // 2 grabs third row in table: Package 3        
      $data['row3'] = $row3;
  </code></pre>