If your structure is really tree-like, then a HABTM relationship is
not really useful.
The main question to an answer is "can one article have several
parents?". As in direct parents, not hierarchy. If it can, then your
structure is not a tree, and HABTM should be used, and you'll have to
create a join table.
If, as your database structure suggests, each article has one (or
zero) parents, then the structure is tree-like and HABTM is not
necessary. Each article "hasOne" parent article and "hasMany" child
articles:
class Article extends AppModel {
var $name = "Article";
var $belongsTo = array('Parent' => array('className' => 'Article',
'foreignKey' => 'article_id'));
var $hasMany = array('Child' => array('className' => 'Article',
'foreignKey' => 'article_id'));
}
Depending on the complexity of your structure, it might be worth
looking at the tree behavior. However, if your nestings aren't very
deep then this approach should work fine.
On Jan 7, 12:50 pm, Seb <[EMAIL PROTECTED]> wrote:
> Hello!
>
> I'm only just starting on the cakephp business, and so far, i'm
> impressed - i've run through most of the tutorials i could find on the
> web relating to cake, and the IBM ones too so got a fairly good
> understanding of what's going on...
>
> I've hit a wall though - in the thing I'm writing at the mo, there is
> a tree structure (of sorts) with:
>
> Issue -> Section -> Article
>
> So, an issue hasMany("Section"). Fine.
> Section hasMany("Article"). Still fine.
> Article hasAndBelongsToMany("Article")
>
> It's the last one that's causing problems - my article table structure
> is something along the lines of:
>
> article(id, article_id, title, body, created, modified)
>
> so i don't have a join table to join the articles on to themselves,
> the article just stores if it has a parent article or not.
>
> I can't get this to work with the scaffolding part I'm working on at
> the moment as it keeps trying to look for a articles_articles table
> (which i don't think (correct me if i'm wrong) i want nor need)
>
> Any help would be greatly appreciated!
>
> Thanks
>
> Seb Maynard
--~--~---------~--~----~------------~-------~--~----~
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 to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
