Database / Relationship question (habtm)

2009-07-21 Thread ulterior
I'm somewhat new to cake, this is my second app and I'm having problems with relationships. The first app I created was pretty straightforward and I had a great time writing it in cake but my database skills aren't up to par with my php! Here goes: I have three tables that contain data which I

Re: Database / Relationship question (habtm)

2009-07-21 Thread brian
How are these 3 models related? Can a Topic belong to more than one Category? And how is Profile related to either of the others? A Topic has a Profile? One or more? What about Category? On Tue, Jul 21, 2009 at 11:06 AM, ulteriorulteriordes...@gmail.com wrote: I'm somewhat new to cake, this

Re: Database / Relationship question (habtm)

2009-07-21 Thread George
You really need to think of the three entities separately first, and decide how they should be related before you go on and start coding. Making an ER diagram is usually very helpful. (look it up if you don't know what an ER diagram is...you'll find a ton of info). It sounds like your app is

Re: Database / Relationship question (habtm)

2009-07-21 Thread ulterior
That actually makes perfect sense. I guess I was trying to overthink the whole thing. Thanks very much! -Chris On Jul 21, 12:27 pm, George geo...@hakumei.net wrote: You really need to think of the three entities separately first, and decide how they should be related before you go on and