Hi everybody, I have a query with inner join that the tables users and pages, the query is the following:
SELECT users.id, users.name, users.last_name, users.organization_id, pages.id AS page_id, pages.title AS page_title FROM users inner join pages on users.id = pages.user_id WHERE users.name ilike '%$variable%' AND pages.page_status = '1' AND pages.allow_page = '1' ORDER BY users.last_name ASC LIMIT $limit OFFSET $offset Where $variable, $limit and $offset are variables. I would like to know how can I make this query in CakePHP 1.1.x using the functions given by the API. I don't want to use the execute nor query functions, I want to know is this query is possible using the find*s function. Thanks in advance, hopefully someone of you can help me, thanks again. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
