title: cakephp, select for a form are generated with a query
body: <p>I have this query in the controller</p>
  
  <pre><code>$clientslist = $this-&gt;Client-&gt;query("SELECT client_name FROM clients WHERE active=1");
  </code></pre>
  
  <p>how can i show my clients list with a select in a form?</p>
  
  <pre><code>echo $this-&gt;Form-&gt;input('clientname', array('type' =&gt; 'select', 'options' =&gt; ??????));
  </code></pre>
  
  <p>thanks</p>
  
  <hr>
  
  <p><strong>EDIT</strong></p>
  
  <p>i've solved my problem</p>
  
  <p>in controller   </p>
  
  <pre><code>$clientslist = $this-&gt;Client-&gt;find('list', array('fields' =&gt; array('Client.client_name'), 'conditions' =&gt; array('Client.active' =&gt; '1')));
          $this-&gt;set('clientslist', $clientslist);
  </code></pre>
  
  <p>in view</p>
  
  <pre><code>echo $this-&gt;Form-&gt;input('cliente', array('type' =&gt; 'select', 'options' =&gt; $clientslist));
  </code></pre>
  
  <p>i have another problem now</p>
  
  <p>in view the value of every option of the selectbox is the id
  how can i use the name of the client in the value?</p>