Hello Matth, ever looked here?
http://book.cakephp.org/complete/164/Pagination Best Regards, Oliver matth schrieb: > I'm having a little trouble setting up my models properly so that I > retrieve my data. This really wasn't an issue until I started messing > around with the paginate helper. > > I have two tables: > hits: col1|col2|col3|item_id > items: id|title > > How do I set up my models so that I can sort by popularity (as in how > many times the id appears in the table hits)? > > Just to be clear I can formulate the actually query in full sql, > that's not really an issue... I have that knowledge. My trouble is > figuring out how the paginate helper formulates which tables to > include in the FROM clause. > > I have my HitModel setup with $belongsTo and ItemModel setup with > $hasMany. > > In debug mode I can see that Cake uses "DESCRIBE items" and "DESCRIBE > hits" but I still can't figure out how to actually get hits into > paginate's FROM clause. > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---