DVD belongsTo Status is the relationship you want to add. (Yes I'm aware DVD's don't actually belong to a status, "belongsTo" is just a name)
Also, shouldn't your table be called statuses instead of status... http://manual.cakephp.org/appendix/conventions On Sep 6, 1:48 pm, jwerd <[EMAIL PROTECTED]> wrote: > Hello Everyone. > > I am writing a DVD rip library software in cake as one of my first > projects. I'll give you the layout and the associations. > > dvds > CREATE TABLE `dvds` ( > `id` int(11) NOT NULL auto_increment, > `title` varchar(55) default NULL, > `body` text, > `status_id` int(11) default NULL, > PRIMARY KEY (`id`) > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 > > titles > CREATE TABLE `titles` ( > `id` int(11) NOT NULL auto_increment, > `title` varchar(155) default NULL, > `body` text, > `dvd_id` int(11) default NULL, > PRIMARY KEY (`id`) > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 > > status > CREATE TABLE `status` ( > `id` int(11) NOT NULL auto_increment, > `name` varchar(55) default NULL, > PRIMARY KEY (`id`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 > > DVD hasMany Title > Title belongsTo DVD > > That association works perfect. Now I want to associate the status > table with the dvds table, so that I can say whether or not the status > is closed or open for the DVD. > > In cake what is the easiest way to quickly do this? Right now I'm > running off just scaffolding because it really doesn't need another > interface and I'm wondering if I can continue to use the scaffolding, > so long as my assoications make sense? Please help :) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
