Check this link http://book.cakephp.org/view/1033/counterCache-Cache-your-count
On Jul 26, 8:07 am, saavedrajj <[email protected]> wrote: > Hi everybody, I have 2 models: Restaurant and Zone > > app/models/restaurant.php > <?php > class Restaurante extends AppModel { > > var $name = 'Restaurant'; > > var $belongsTo = array( > 'Zone' => array( > 'className' => 'Zone', > 'foreignKey' => 'zone_id' > ) > > ); > > } > > ?> > > app/models/zone.php > <?php > class Zone extends AppModel { > var $name = 'Zone'; > > var $hasMany = array( > 'Restaurant' => array( > 'className' => 'Restaurant', > 'foreignKey' => 'zone_id' > ) > ); > > } > > ?> > > And I need to execute this query: > > SELECT restaurants.zone_id, zones.title, COUNT(restaurants.zone_id) AS > zonecounter > FROM restaurants, zones > WHERE restaurants.sector_id = zones.id > GROUP BY restaurants.sector_id > ORDER BY zones.nombre ASC > > So, T wrote the next function at my Restaurant controller > > app/controllers/restaurant_controller.php > <?php > class RestaurantsController extends AppController { > > var $name = 'Restaurants'; > var $uses = array('Restaurants', 'Zones'); > > function index() { > $this->set('zones', $this->Zone->Restaurant->find('all', > array( > 'fields' => array('Restaurant.zone_id', 'Zone.title', > 'COUNT(Restaurant.zone_id) AS zonecounter'), > 'conditions' => array('Restaurant.city_id' => 4), > 'order' => array('Zone.title ASC'), > 'group' => array('Restaurant.zone_id') > ) > > ) > );} > > ?> > > *PS: At 'conditions' I need a value for Restaurant.city_id, because > I'm using this function for more cities. > > Then, in my index view, to show the results that I have > > app/views/restaurants/index.ctp > > <div> > <h2>Zones</h2> > <ul> > <?php foreach ($zones as $zone): ?> > <li><?php echo $html->link($zone['Zone']['title'], '#');?></li> > <?php endforeach; ?> > </ul> > </div> > > It shows me something like > > Ex: > Zones > - Zone 1 > - Zone 2 > - zone 3 > - Zone 4 > > Shows me only the zones where are restaurants. Cool. > > But also I need to show the value of "zonecounter" in order to > display how many restaurants are in every zone: > > Ex: > Zones > - Zone 1 (22) > - Zone 2 (31) > - zone 3 (16) > - Zone 4 (24) > > Some ideas? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
