CakePHP Questions

Hi,

I made the following table which describes hierarchical relation of categories. The table name is categories

id:
name:
description:
category_id

I mean by this design to have self join for this table where the category_id field handles the id...

Hi there,

I have a bit of a beastly query involving joins etc that is working fine using the $model-query() method, but I would like to make it the more 'cakey' way... but I'm having no luck, could anyone take a look for me?

Current method:

$sql =...