In the controller you would do:
$this->loadModel('Page');
$this->set('pages', $this->Page->find('list'));
Simple and easy. I don't know if this is the "right" way, but its what
I was shown long ago and it has never failed me.
On Mar 12, 7:02 am, Graham <[email protected]> wrote:
> Dear All. I would like some advice please. I am new to CakePHP and so far I
> am loving it. I am keen to do things the “right way” so I am interested in
> any comments.
>
> What I describe in the following I have working. I am interested in knowing
> if I have gone about it the right or wrong way.
>
> I have a table with a varchar field that I want to complete with data from
> another table – my choices table. There is no connection between the two
> tables.
>
> In my controller I have the following:
>
> App::import('Model', 'Choice');
>
> $tmpChoice = new Choice();
>
> $titles = $tmpChoice->find('list', array(
>
> 'fields' => array('item', 'item'),
>
> 'conditions' => array('cat' => 'title'),
>
> 'recursive' => 0
>
> ));
>
> $this->set(compact('titles'));
>
> I have this in my view:
>
> echo $this->Form->input('title',
> array('type'=>'select','options'=>$titles));
>
> Above, I needed to instantiate the Choice model class to make it available
> to my code. When I used:
>
> $titles = $this->MainTable->Choice->find('list',…
>
> I received an error saying that I was trying to execute a function of an
> object that isn’t a class. I resorted to my above code to resolve the error.
>
> The “fields” array specifies “('item', 'item')”. This I did so that I could
> have the value and the option the same – I didn’t want to insert the id key
> into the database, I wanted the text. The “conditions” statement is present
> so that I can select the appropriate category of choices.
>
> Thanks for looking at this and making any comments about the code.
>
> With regards
>
> Graham Jones
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
