How do you have your Models setup?
Book
$hasMany = array('Log' => array('className' => 'Log',
'foreignKey' => 'book_id'));
$belongsTo = array('User' => array('className' => 'User',
'foreignKey' => 'user_id'));
Log
$belongsTo = array('Book' => array('className' => 'Book',
'foreignKey' => 'book_id'),
'User' => array('className'
=> 'User', 'foreignKey' => 'user_id'));
If it is setup like this and you have user_id field in books table,
then it should work. If Book does not have user_id, then you may
have to do something like a sub query of Log.user_id=2, and then
join that with Book on book_id. or something like that.
Can you create a mySQL statement to pull the data out? if so, then
post the SQL and maybe someone can help explain how to do this.
HTH.
Bill
On 5/6/2012 6:33 PM, Rob-3 [via CakePHP] wrote:
Hi,
Let me try to clarify because I think I've confused even myself at
this point lol
I have 3 books that I am trying to retrieve from the database.
Users
have added these books to reading logs, but I want to return each
book, and then only the logs where the user id is equal to the
current
user (lets say two)
right now using Log.user_id = 2 i get the following array
Book 1
Empty log array
Book 2
log array, userid = 2
Book 3
log array, userid = 2
log array, userid = 3
That third book, where the extra log is returned is what I don't
want
happening. Does this make more sense?
On May 6, 1:06 am, bs28723 < [hidden email] >
wrote:
> Are you looking for a find where&nbsp;
"Log.user_id=2 OR Book.log_id =
> null"?
>
> On 5/3/2012 11:00 PM, Rob-3 [via CakePHP] wrote:
> I have a setup where there are Books Users and Logs.
> Each Log has a
>
> Book and a User and I am trying to retrieve a list of
all the
> books
>
> regardless of the user, but then also retrieve the
Logs associated
>
> with that book (recursive is set to 1), but then only
retrieving
> the
>
> logs of the current logged in user.
>
> Hopefully that's clear. I tried using Containable and
like so:
>
> $this-&gt;Book-&gt;contain('Log.user_id =
2');
>
> But unfortunately this leaves out Books for which
User 2 has no
> logs
>
> for. Am I going about this correctly and I'm just not
using
>
> containable properly, or am I doing this all wrong.
>
> Let me know if anything needs to be clarified or
expanded...Any
> help
>
> is appreciated!
>
> --
> Our newest site for the community: CakePHP Video
Tutorialshttp://tv.cakephp.org&nbsp;
>
> Check out the new CakePHP Questions
sitehttp://ask.cakephp.org&nbsp;and
> help others with their CakePHP related questions.
>
> To unsubscribe from this group, send email to
>
> [hidden email]
> For more options, visit this group
athttp://groups.google.com/group/cake-php
>
> If you reply to this email, your
> message will be added to the discussion below:
>
http://cakephp.1045679.n5.nabble.com/CakePHP-Containable-on-Associate ...
>
> To start a new topic under CakePHP, email
> [hidden email]
> To unsubscribe from CakePHP, click
> here .
> NAML
>
> --
> View this message in context:
http://cakephp.1045679.n5.nabble.com/CakePHP-Containable-on-Associate ...
> Sent from the CakePHP mailing list archive at Nabble.com.
--
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
[hidden email]
For more options, visit this group at
http://groups.google.com/group/cake-php
If you reply to this email, your
message will be added to the discussion below:
http://cakephp.1045679.n5.nabble.com/CakePHP-Containable-on-Associated-Model-tp5684781p5689882.html
To start a new topic under CakePHP, email
[email protected]
To unsubscribe from CakePHP, click
here .
NAML
--
View this message in context:
http://cakephp.1045679.n5.nabble.com/CakePHP-Containable-on-Associated-Model-tp5684781p5692635.html
Sent from the CakePHP mailing list archive at Nabble.com.
--
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
