and how to to this the object oriented way (with fetchAll()) ??
many thanks!
Alex
On Tue, 13 Feb 2007 14:59:24 +0100, Kaste <[EMAIL PROTECTED]> wrote:
>
>> select posts.id, comments.id, count(comments.id) as commentscount from
>> posts, comments where comments.posts_id = posts.id where commentscount =
>> 0
>> group by posts.id;
>>
>
> select p.* from posts p left join comments c on c.post_id=p.id where c.id
> is null;
>
>
>> Right?
>
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
