I am working on movie site. Client have movie records in following structure.
CREATE TABLE IF NOT EXISTS `movies` ( `id` int(50) NOT NULL AUTO_INCREMENT, `movieName` varchar(500) NOT NULL, `year` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; -- -------------------------------------------------------- CREATE TABLE IF NOT EXISTS `celebrities` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(250) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; -- -------------------------------------------------------- CREATE TABLE IF NOT EXISTS `casts` ( `movie_id` int(50) NOT NULL, `role` varchar(200) DEFAULT NULL, `celebrity_id` int(11) NOT NULL DEFAULT '0', KEY `movieid` (`movie_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; As you can see movies has casts, casts table contains movie_id and celebrity_id. celebrities master table is for storing all master celebrity names. Now my problem is i have created models for movie and celebrity like movie hasmany cast. In movie page aim getting movie details along related casts. But celebrity_is is showing id instead of name.... how can i get celebrity name instead of id. Please help me. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---