Hello
I wonder if anyone can help me with a specific database design. I have
a database with pictures of people. A person may be on different
pictures, and a picture may have many people on it (so its a
HasAndBelongsTo relation with 3 tables...)
My problem is that, on a view of a person, I want to list all the
pictures of that person, PLUS all other the people that show up in the
same photo! So its hard because if try to find() this person with
recursion 2, it will fetch the associated pictures, but not the
people, since it already passed by the people table. So I'm getting
something like this:
Array
(
[Person] => Array
(
[id] => 1
[name] => Bob
)
[Picture] => Array
(
[0] => Array
(
[id] => 114
[description] => Oh what a nice picture
)
[1] => Array
(
[id] => 115
[description] => Oh what a lovely picture
)
)
)
When actually I need something like this:
Array
(
[Person] => Array
(
[id] => 1
[name] => Bob
)
[Picture] => Array
(
[0] => Array
(
[id] => 114
[description] => Oh what a nice picture
[Person] => Array(
[0] => Array (
[id] => 2
[name] => Alice
)
)
(...) and so on
has anyone come across such a problem? How can I get around it?
Thank You
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
