Hi,
I think you should specify the relation in the `job_title` model
http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html#hasone
Then the find() method should return you the related values as
associative arrays.
To adapt & normalize the results, eg. a single array, look at model
callback (eg. afterFind)
http://book.cakephp.org/2.0/en/models/callback-methods.html
Il 28/12/2011 02:18, robbie ha scritto:
Hi folks,
I imagine a good search would help me find the answer to my problem,
but unfortunately, I don't know the words to use to describe my
problem. So, I'll describe it here and seek either the terminology I
need to learn more or possibly the solution.
I'm completely new to CakePHP but somewhat familiar with PHP and
MySQL. Familiar enough with the later, that I've decided I need to
first to make a better application.
Imagine I have the following database tables.
TABLE job_title
id
desc
level
TABLE job_levels
id
desc
A record in the job_title table would look something like:
id = 1
desc = CakePHP Developer
level = 3
And the job_levels table has the following data
id = 3
desc = Senior
So, in this case, when I do a join in MySQL, I'd get a job_title
record that looks something like:
id = 1
desc = CakePHP Developer
level = 3
desc = Senior
Basically, I'm substituting the job level id for the job level desc.
Now, how do I do the same in CakePHP?
I built put an association in the model for Job but that doesn't
return exactly what I want. Essentially, for each job, I'd like to
have the level description available in the model. At least I think
this is what I want. Maybe there is some concept I'm missing that
would make this unnecessary.
Hopefully this makes sense. Any help or advice is greatly
appreciated.
robbie
--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
