title: Zend Framework ORDER BY
body: <p>I have a list of items that I want to order in alphabetical order, heres my code:</p>
  
  <pre><code>public function indexAction()
  {
      $this-&gt;authoriseUser();
      $this-&gt;view-&gt;assign('title', 'Clubs');
      $this-&gt;view-&gt;headTitle($this-&gt;view-&gt;title, 'PREPEND');
      $clubs = new Application_Model_DbTable_Clubs();
      $this-&gt;view-&gt;clubs = $clubs-&gt;fetchAll();
      $select = $clubs-&gt;select();
      $select-&gt;order('club_name ASC');
  }
  </code></pre>
  
  <p>Whats wrong? As it doesn't work..</p>
  
  <p>Thanks</p>