I've done the following:
Clipranking Model:
function findClipByRank($site_id){
                return $this->query("SELECT Clipranking.rank, 
Clipranking.site_id,
Clipranking.required, Clip.id, Clip.name, Clip.length FROM
cliprankings AS Clipranking, clips AS Clip WHERE Clipranking.site_id =
$site_id AND Clipranking.clip_id = Clip.id");
        }

And calling in my controller works fine: $clip = $this->Site-
>Clipranking->findClipByRank($id);

In my short experience with Cake, it seems that there would be a more
Cake-ish way to accomplish this.   I'm a noob here so, it's probably
obvious.

Thanks,
Jeremy
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to