Re: Convert this Mysql Statement to a cakePHP find array

2009-07-14 Thread Dr. Loboto
$this->PrintIssue->find( 'first', array ( 'fields' => array ('id', 'issue_date'), 'conditions' => array ('id >=' => 2043), 'page' => 46 ) ); On Jul 14, 1:09 pm, liaogz82 wrote: > Hi all, > > I am having some difficulty finding a cakePHP solution to this MySQL

Re: Convert this Mysql Statement to a cakePHP find array

2009-07-14 Thread RC
Possibly something like: $print_issues->find(array( 'fields' => array('id', 'issue_date'), 'limit' => 45, 'offset' => 1, 'conditions' => array( 'id >=' => 2043, ) ); Untested, not sure wether it'll work though. :) On Jul 14, 1:09 pm, liaogz82 wrote: > Hi all, > > I

Re: Convert this Mysql Statement to a cakePHP find array

2009-07-13 Thread jeff
USE THE CAKEPHP $this->model_name->querry(); format... =>To make custom queries use the foll *Syntax:* $this->model name->query(" sql query here “ ); Eg: $this->Employee->query("SELECT employee_name,employee_ID,company,basic_salary FROM Employees WHERE id='$id';")); refer the l

Convert this Mysql Statement to a cakePHP find array

2009-07-13 Thread liaogz82
Hi all, I am having some difficulty finding a cakePHP solution to this MySQL statement: SELECT `id`, `issue_date` FROM icapsdb3.print_issues where id >=2043 limit 45,1 Can somebody help me please? --~--~-~--~~~---~--~~ You received this message because you are su