How to limit db query data in CakePhp?

Question

I want to limit my db data on CakePhp. It can be limited with find command but I don't know is it possible to limit with my usage. Here is my code from posts_controller.php file:

function index() {  
    $this->Post->order = array('order'=>'Post.date DESC','limit'=>5);  
    $this->Post->recursive = 0;  
    $this->set('posts', $this->paginate());  
}

Young · Accepted Answer · 2010-07-01 10:03:05Z

3

You can try:

$this->paginate['Post'] = array('order'=>array('Post.date DESC'),'limit'=>5,'recursive'=>0);      
$this->set('posts', $this->paginate('Post'));

For more information see the cookbook.

answered Jul 1, 2010 at 10:03

Young

8,4627 gold badges47 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

aiternal Over a year ago

You are great SpawnCxy thank you very much. I am new at CakePhp and/so couldn't understand some basics yet.

Collectives™ on Stack Overflow

How to limit db query data in CakePhp?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related