Must be a simple one. I want to use cakephp model behaviour to do this. Can you help?
I have a user table which stores id(s) for city, secretquestion etc., so my 'user' table has city_id and secretquestion_id and the actual names/texts for these are stored in City & Secretquestion tables respectively.
Now, I am coding UsersController. When I read my User table, I get these IDs obviously. But I need to retrieve these names (City Name, Secretquestion Text) for subsequent use.
How can I do that? Can someone shed light on the steps involved?
I can simply write a SQL and do that but I want to utilize CakePHP Model functionality and handle this the CakePHP way.