how can i concat first_name and last_name two different database fields to assign to drop down list in cakephp using 'list' in find statement

$swimmer = $this->Swimmer->find('list', array(
    'condition开发者_如何学Pythons' => array('Swimmer.group' => $this->data['Swimmer']['group_id']),
    'order' => array('Swimmer.first_name ASC'),
    'fields' => 'Swimmer.first_name'
));

---

First of all, setup a virtual field in your Swimmer model as suggested by Ann Pham. eg:

var $virtualFields = array(
    'name' => "CONCAT(Swimmer.first_name, ' ', Swimmer.last_name)"
);

Then, fetch the data for your dropdown list like so: (assuming Swimmers controller)

$this->Swimmer->find('list', array('fields' => array('Swimmer.id', 'Swimmer.name')));

---

You could also try doing this in your SwimmerModel: var $displayName = 'Swimmer.name'; (not 100% sure if this would work). If it does work, you won't need the 'fields' array in the find.

---

An another approach is to concat the field on the fly in the fields list.

Ex:

$swimmer = $this->Swimmer->find('list',
array(
    'conditions' => array(
        'Swimmer.group' => $this->data['Swimmer']['group_id']),
    'order' => array(
        'Swimmer.first_name ASC'
    ),
    'fields' => 'CONCAT(Swimmer.first_name, " ", Swimmer.first_name) AS full_name'
));

---

http://book.cakephp.org/view/1588/virtualFields