Does anyone knows how to write the following limit syntax within the paginate function of cakephp : limit 0,5 normally what we do is, $this->paginate['limit'] = 10; but it is not taking like the above format.... im talking of something like $this->Book->find($condition,$fields,$order,"0,5") Thanks in advance...
I'm not sure if I completly understand you, but using limit with the find function works like this: $this->Book->find('all',array('limit'=>'10','conditions'=>array('cat_id'=>'3'),'order'=>'id')); PHP: is SELECT * FROM books WHERE cat_id = '3' ORDER BY id LIMIT 10 Code (markup):
I want a limit like 0,5 in the paginate function of CakePHP (not find)... Plainly speaking, i want this query with the paginate function : SELECT * FROM tabs LIMIT 0,5; Thanks,