title: Creating full select dropdown from SQL using Fat Free Framework
body: <p>I'm trying to fill a select dropdown using SQL with Fat Free Framework</p>
  
  <p>The SQL is basic and standard:</p>
  
  <pre><code> SELECT * FROM `lines_list`;
  </code></pre>
  
  <p>will return id, type</p>
  
  <p>all I need it do do is fill a select box:</p>
  
  <pre><code> &lt;option value=$row['id']&gt;$row['type']&lt;/option&gt;
  </code></pre>
  
  <p>f3 is confusing the life out of me now but I need to get my head around it. </p>
  
  <p>Can anyone shed some light?</p>
  
  <p>EDIT:</p>
  
  <p>I need to know the right code within f3, here is what I have at the moment:</p>
  
  <pre><code>    $rows=$this-&gt;db-&gt;exec('SELECT * FROM line_list ORDER BY id DESC');
      foreach($rows as $row)
         echo $row['type'];
  </code></pre>
  
  <p>which will happily echo the list but I don't know how to use this information properly in f3.</p>