Okay, thanks for your reply but from where I get the $id. This should be Client.id but... this query selects only one row but I need to select only one row for each client. I have 1000 clients and 21290 reports. For every client I need to select the date of last report.
On 11 sep., 21:52, Miles J <[email protected]> wrote: > Well you would have to grab the last date. Heres a query, assuming you > followed cake conventions. > > $result = $this->Report->find('first', array( > 'fields' => 'Report.created', > 'order' => 'Report.id DESC', > 'conditions' => array('Report.client_id' => $id) > )); > > Then echo it in the view: echo $result['Report']['created']; > > On Sep 11, 11:42 am, sindbad <[email protected]> wrote: > > > Hi, > > > first of all I want to say that I'm new to cake but with a little help > > from book.cakephp.org and Google I've made a simple application for > > managing clients and reports for the clients. > > Each client has many raports. Now, in the index view of the clients I > > need to show the date of last report. This is what I don't know how to > > do it. > > I'll be glad if you could tell me how to select only the date of the > > last report for each of my clients. > > Thanks. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
