Query conditions on related tables in CakePHP

Today I came across an interesting problem. When using the recursive features of CakePHP to return a results tree it isn’t possible to refine the results by a condition on the related table when it is a one to many relationship. Take the follow example:
I have 4 tables:
User
[...]

CakePHP: Displaying the correct label for lists and drop downs

A little way into my project, after setting up CakePHP and baking my MVC’s i hit a stumbling block. When i used viewed the edit and add forms, the drop downs just showed Numbers, the Id of each related item to be precise.

As you can see this isn’t much help.
The data is pulled in using [...]

Getting back into cakePHP

I have just started an internal project at work to create a portfolio management system. After several months of Joomla hacking it seems this is my chance to get back into serious development again.
I have gone for cakePHP for the project, as opposed to Codeigniter. Although I have mainly tended towards codeigniter in the past [...]