a question on model relationships

2009-05-14 Thread Beedge
Hey all, I have (or plan to have!) an app that will allow users to view products by category. Each category can have a sub category and each sub category can have further sub categories.. eg. sportstennisracketswooden There is no limit to the dept of sub categories.. (like in Ebay) I plan to

Re: a question on model relationships

2009-05-14 Thread PaulMan
Try Tree Behavior for category-SubCategory-SubCategory , and workit all in the same model Category ... Product Model public $hasAndBelongsToMany = array('Category'); Category Model public $hasAndBelongsToMany = array('Product'); public $hasMany = array('SubCategory'=

Re: a question on model relationships

2009-05-14 Thread Beedge
Thats great thanks, looking at the cook book section on tree's and although I dont quite get it at first glance, it looks like its exactly what I need Thanks again, Kevin On May 14, 10:49 am, PaulMan pho...@gmail.com wrote: Try Tree Behavior for category-SubCategory-SubCategory , and workit

Re: a question on model relationships

2009-05-14 Thread Beedge
Now that I think about it, would a tree structure mean that each sub category can only appear in one tree? e.g a furniture shop might have Living room tables and Dining Room tables so can the sub category tables appear in both trees? --~--~-~--~~~---~--~~

Re: a question on model relationships

2009-05-14 Thread PaulMan
No, I Tree has unique branches.. A Table for Dining Room , is not a table for a Living Room but i think if you reverse the order you will get more organized put Tables( id:5 ) - Living Room ( id:6 ) Tables( id:5 ) - Dinning Room ( id:7 ) * ids are only examples and on the

Re: a question on model relationships

2009-05-14 Thread brian
On Thu, May 14, 2009 at 6:50 AM, PaulMan pho...@gmail.com wrote: No, I Tree has unique branches.. A Table for Dining Room , is not a table for a Living Room but i think if you reverse the order you will get more organized put Tables( id:5 ) - Living Room ( id:6 ) Tables( id:5 ) -

Re: a question on model relationships

2009-05-14 Thread PaulMan
You should analize you problem realy good, I has a similar problem, on a Food Chain Distribution B2b Site and it worked 5 Stars for me. Good Luck... On May 14, 4:28 pm, brian bally.z...@gmail.com wrote: On Thu, May 14, 2009 at 6:50 AM, PaulMan pho...@gmail.com wrote: No, I Tree has

Re: Question about model relationships

2007-03-01 Thread AD7six
On Mar 1, 6:02 pm, Anthony [EMAIL PROTECTED] wrote: OK, I'm aware this is probably a very dumb, newbie question, but you gotta start somewhere, right? Say I have a users table and a messages table. For each ONE user, there are MULTIPLE messages. However, when doing a findAll on the users,

Re: Question about model relationships

2007-03-01 Thread Anthony
Thanks, that solved the problem!! - Anthony --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email