You would put the mysql format date on the fields. Round.id, and Round.rounddate.
If that doesn't work you'll have to do a loop, nothing wrong with loops! On Sep 11, 10:05 am, Gerard <[email protected]> wrote: > Thanks. I would prefer to stay away from the loop but will implement > it if I have to. My current find statement is as follows: > $rounds = $this->Tip->Round->find('list', array('fields' => array > ('Round.id', 'Round.rounddate'))); > > This gets the two fields to populate the select field with the ID and > the date. Is there an $option setting to change the output, I can't > find it in the "book"? Or are you suggesting I just use the custom > query command - which would be way too simple and I'm embarrassed I > didn't think of it? > > Thanks > > On Sep 12, 12:51 am, WebbedIT <[email protected]> wrote: > > > either modify your find which generates the list to get mysql to > > reformat the dates, or run the array through a loop which uses > > something like date('d-M', strtotime($date)); to reformat the values. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
