Sunday, October 30, 2011

query

Hi,
I have an query and I could not figure it out what is the cakephp form of it.

query:
-------------------------------------------
SELECT *
FROM
  tags`
  INNER JOIN `tags_articles` ON (`tags`.`id` = `tags_articles`.`tag_id`)
  INNER JOIN `articles` ON (`tags_articles`.`article_id` = `articles`.`id`)
WHERE
  `articles`.`isRead` = 'Not' AND 
  `tags`.`id` = 3 AND 
  `articles`.`status` = 'New'
ORDER BY
  `articles`.`name` DESC
----------------------------------------------------------------------------------------------
Thnks..
ST

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

No comments: