After handing out so much help (some good, some bad) I need some help getting a query to work with the models.
Currently, I have the following two queries using the model: $start_results = $this->Stat->findAll("Site.category = {$category} AND Stat.s_date = '{$start_date}'"); $finish_results = $this->Stat->findAll("Site.category = {$category} AND Stat.s_date = '{$finish_date}'"); Site as a hasMany relationship with Stat Stat has a belongsTo relationship with Site Now, what I need to do is change the query to do the following select min(members) as from stats where site_id =<site_id goes here> AND (s_date >= '<start_date>' AND s_date <= '<finish_date>'); select max(members) from stats where site_id = <site_id goes here> AND (s_date >= '<start_date>' AND s_date <= '<finish_date>'); I need to have model-derived results sets so that I don't have to change any following code: if (is_array($start_results) && is_array($finish_results)) { $report_date = "{$start_date} to {$finish_date}"; foreach ($start_results as $result) { $site_id = $result['Site']['id']; $site_name[$site_id] = $result['Site']['name']; $start_members[$site_id] = $result['Stat']['members']; $start_threads[$site_id] = $result['Stat']['threads']; $start_posts[$site_id] = $result['Stat']['posts']; } foreach ($finish_results as $result) { $site_id = $result['Site']['id']; $finish_members[$site_id] = $result['Stat']['members']; $finish_threads[$site_id] = $result['Stat']['threads']; $finish_posts[$site_id] = $result['Stat']['posts']; } // Figure out the distances in the range if (is_array($start_members)) { foreach ($start_members as $site_id => $data) { $members[$site_id] = $finish_members[$site_id] - $start_members[$site_id]; $threads[$site_id] = $finish_threads[$site_id] - $start_threads[$site_id]; $posts[$site_id] = $finish_posts[$site_id] - $start_posts[$site_id]; } } } Any help would be greatly appreciated. -- Chris Hartjes "The greatest inefficiencies come from solving problems you will never have." -- Rasmus Lerdorf @TheBallpark - http://www.littlehart.net/attheballpark @TheKeyboard - http://www.littlehart.net/atthekeyboard --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---