Re: HABTM retrieving help

2009-01-04 Thread Bernardo Vieira
If I understood correctly you're trying to paginate realated HABTM data based on some condition on the join table? Have a look at http://cakebaker.42dh.com/2007/10/17/pagination-of-data-from-a-habtm-relationship/ and http://www.cricava.com/blogs/index.php?blog=6&title=modelizing_habtm_join_ta

Re: HABTM retrieving help

2009-01-04 Thread gearvOsh
I know how to pagination, but. I would like to do the pagination from the Team model, but the data I need to access is in the TeamsPlayer model. Understand? On Jan 4, 8:01 am, Smelly_Eddie wrote: > You would read the Cake Manual section on pagination which answers all > your questions.http://bo

Re: HABTM retrieving help

2009-01-04 Thread Smelly_Eddie
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 wrote: > Heres my tables and relations: > > Team > Team->belongsTo: Country, State > Team->hasAndBelongsToMany: User (the players on a t

HABTM retrieving help

2009-01-03 Thread gearvOsh
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',