Hello again :-)
Ok, I think I understand, misinterpreted your question.
I am not sure, if this is the best solutioin (honestly I don't think
so), but you could do a custom query
... in the UsersController:
_________________________________________
$query = <<< SQL
select
Users.id as user_id,
Users.name as user_name,
Singers.id as singer_id,
Singers.name as singer_name,
count(Songs.id) as songs_in_lib
from
Users left join Songs_users on Users.id = Songs_users.user_id,
Singers left join Singers_songs on Singers.id =
Singers_songs.singer_id,
Songs
where
Songs.id = Singers_songs.song_id and
Songs_users.song_id = Songs.id and
Users.id = 1
group by
Users.id,
Users.name,
Singers.id,
Singers.name
order by
Users.name,
Singers.name
SQL;
$data = $this->User->query($query);
$this->set('data',$data);
_________________________________________
In this case, we know the user ("User.id = 1"). "count(Songs.id) as
songs_in_lib" gives you the number of songs by an singer in this users
library.
I hope that helps you a little. It would be nice to know, if it is
nescessary to fetch all data at once ... you could do it in more than
one step. This depends on how die GUI works, for example: list users ->
klick on user -> show all singers in his library ...??
Regards, Christoph :-)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
