title: cakephp query with conditions limit and order
body: <p>I want to retrieve the last 3 registered users in cakephp using the field <code>created</code> in table <code>Users</code>.</p>
  
  <p>In my controller I have:</p>
  
  <pre><code>$this-&gt;User-&gt;recursive = 1;
      $this-&gt;set('users',
          $this-&gt;User-&gt;find('all',
               array('conditions'=&gt; array(
                    'limit' =&gt; 3,
                    'order' =&gt; array(
                    'created' =&gt; 'asc'
                    )
               )
           )
      )
  );
  </code></pre>
  
  <p>The code above when run returns this error:</p>
  
  <pre><code>Syntax error or access violation: 1064 You have an error in your SQL 
  syntax; check the manual that corresponds to your MySQL server 
  version for the right syntax to use near 'order = ('asc')' at line 
  </code></pre>
  
  <p>What must I do to resolve the error?</p>