Not working. It shows me only the last date of the last report.
On 12 sep., 00:38, Miles J <[email protected]> wrote:
> Well if its for multiple clients, just remove the conditions array.
>
> On Sep 11, 12:42 pm, sindbad <[email protected]> wrote:
>
> > 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
-~----------~----~----~----~------~----~------~--~---
