You would read the Cake Manual section on pagination which answers all your questions. http://book.cakephp.org/view/164/pagination
On Jan 3, 10:30 pm, gearvOsh <[email protected]> wrote: > Heres my tables and relations: > > Team > Team->belongsTo: Country, State > Team->hasAndBelongsToMany: User (the players on a team, table = > teams_players) > > Team: > CREATE TABLE IF NOT EXISTS `teams` ( > `id` int(10) NOT NULL auto_increment, > `status` enum('approved','pending') NOT NULL default 'pending', > `name` varchar(50) NOT NULL, > `tag` varchar(10) NOT NULL, > `urlName` varchar(30) NOT NULL, > `website` varchar(50) NOT NULL, > `irc` varchar(20) NOT NULL, > `about` varchar(255) NOT NULL, > `servers` varchar(100) NOT NULL, > `logo` varchar(100) NOT NULL, > `createDate` int(10) unsigned NOT NULL default '0', > `state_id` int(10) unsigned NOT NULL default '0', > `country_id` int(10) unsigned NOT NULL default '0', > `created` datetime default NULL, > `modified` datetime default NULL, > PRIMARY KEY (`id`), > KEY `state_id` (`state_id`), > KEY `country_id` (`country_id`) > ) > > TeamsPlayer > CREATE TABLE IF NOT EXISTS `teams_players` ( > `id` int(11) NOT NULL auto_increment, > `team_id` int(10) unsigned NOT NULL, > `user_id` int(10) unsigned NOT NULL, > `role` enum('leader','captain','member') NOT NULL default 'member', > `status` enum('approved','pending') NOT NULL default 'pending', > `joinDate` int(10) NOT NULL, > PRIMARY KEY (`id`), > KEY `team_id` (`team_id`), > KEY `user_id` (`user_id`) > ) > > Ok if I do a basic Team->find() all the data is returned correctly. > > Now the problem im running into is how do I grab all teams that I am > part of, and paginate it at the same time? Since the user_id values is > in TeamsPlayer, im getting confused on this. Any help would be > appreciated. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
