You have a few ways of doing this, but I would say the easiest is this one:
$list = $degrees->find()->combine('id', function($entity) {
return $entity->name . $entity->degree;
});
You can also use find('list'), but in that case I would suggest reading its
documentation so you understand how fields are passed to it.
Cheers!
On Monday, June 16, 2014 1:21:47 PM UTC+2, archana goyal wrote:
>
> My code for array is
>
> $degrees = TableRegistry::get('Degrees');
> $degreelist = $degrees->find('list', ['fields' => ['id',
> 'concat(name,degree) as name']]);
>
> not created dropdown but if I create query
>
> $degrees = TableRegistry::get('Degrees');
> $degreelist = $degrees->find('list', ['fields' => ['id', 'name']]);
> dropdown created but I need first one.
>
> in mysql query will be :-
> SELECT id,concat(name,degree) FROM `degrees`
>
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
