gistfile1.php

<?php

  public function configure()
  {
    $this->setWidget('hab_customer_location_list', $this->getHabLocationChoiceWidget());
  }


  protected function getHabLocationChoiceWidget()
  {
    $c = new Criteria();
    $c->clearSelectColumns();
    $c->addSelectColumn(HabLocationPeer::ID);
    $c->addSelectColumn(HabLocationPeer::STATE);
    $c->addSelectColumn(HabLocationPeer::CITY);
    $c->addAscendingOrderByColumn(HabLocationPeer::STATE);
    $c->addAscendingOrderByColumn(HabLocationPeer::CITY);
    $stm = HabLocationPeer::doSelectStmt($c);
    
    $locations = array();
    while ($row = $stm->fetch(PDO::FETCH_ASSOC))
    {   
      $locations[$row['ID']] = $row['STATE'].' - '.$row['CITY'];
    }   

    return new sfWidgetFormChoice(array('choices' => $locations, 'multiple' => false));
  }