Hello who can help me out? I searched the group but can't find or
understand ;-) de current answers.
I use the pagination script by AD7six and try to use it with a custom
query like this in the controller.
$criteria= $_GET['id'];
list($order,$limit,$page) = $this->Pagination->init($criteria);
$data= $this->User->query("SELECT DISTINCT
User.id,firstname,User.quote FROM
users as User
LEFT JOIN userjobids as uj ON User.id = uj.user_id
LEFT JOIN jobids as job ON job.id = uj.jobid_id
WHERE job.id = '$criteria'
", NULL, $order, $limit, $page);
$this->set('data',$data);
The the pagination is not set (I guese) cause all records are shown
and the array isn't divided in chunks.
Thnx
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
