My debug value is set to 2, and it's displaying all the queries, except the one I need. I have an Items controller method that is calling this method in the User model (Item belongsTo User): func...

I have a registration form in which users can fill in two email address (email1 & email2). Marketing's requirement is that they need to be unique (unique as in if we had 10 users, then there wo...

I have two tables with field username in both. How i can specify field name for both local and foreign table? I want CakePHP will do something like ON (`T1`.`username` = `T2`.`username`)` in r...

I have a very simple application with 1 table, each row contains a word, it's definition, and an example. The definition and example fields are varchars(5000). On every page, I have a sidebar whi...

Using saveAll() to save multiple records in CakePHP, I am able to save them successfully in a table. But the problem arises while retrieving the IDs of those saved rows. LastInsertID() returns only...

I'm writing an application which supports multiple units of measurement. In the rare event a user wanted to change their system of measurement, I need to run a query which applies a multiplier to s...

I am new to cakephp. I want to know if it is possible in cakephp to to handle multiple model commit and rollback with single transaction. I want to do some thing like this <?php function add(){...

I have 3 tables that contain user information, one for students, one for teachers and one for administrators. They are not related in any way. I wan't to create a dashboard for the Administrators,...

I realize that these might not necessarily be a huge performance issue, but I'd like to get rid of any unnecessary SHOW FULL COLUMNS FROM queries that Cake generates. I've tried using the Containab...