how can i get the page number in a model

i created an application that has a navigation bar.
the query is complex, and the count of returned records varies from
page to another.
i need to get the current page number in my model to use it in the
query, is this possible?

here is the code:

/////////////// the controller ///////////////
class LessonsController extends AppController {
var $name = 'Lessons';
var $paginate = array('Lesson' => array('limit' => 2, 'page' => 1));

function friday() {
$this->set('lessons', $this->paginate('Lesson'));
//print_r($this->paginator->params); // this works very fine here,
but does not work in the model
}
}

/////////////// the model ///////////////
class Lesson extends AppModel {
var $name = 'Lesson';

function paginate($conditions, $fields, $order, $limit, $page = 1,
$recursive = null, $extra = array()) {

return $this->query(
"SELECT *
FROM lessons
WHERE YEAR(created) = (
SELECT DISTINCT( YEAR(created)))
FROM lessons
ORDER BY id DESC
LIMIT $the_page_number ,1)
ORDER BY id DESC");
}
}
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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?hl=en
-~----------~----~----~----~------~----~------~--~---