I would appreciate someone pointing me to a reference which explains
how to code something like this in CakePHP:
SELECT user_photos.name
FROM user_photos
WHERE user_photos.userID IN (
SELECT users.recordID
FROM users,
user_additions
WHERE (
users.type = "F"
AND
users.status = "1"
AND
users.recordID IN (
SELECT user_additions.userID
FROM user_additions
WHERE (
user_additions.genre = "Alternative"
AND user_additions.gender = "F"
AND user_additions.age BETWEEN "15" AND "45"))))
LIMIT 0, 100;
This statements works correctly in the database and I have models
UserPhoto, User and UserAddition.
Thanks for any help.
Regards,
Peter -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
