is there an example somewhere on how to use pager_query? there's no example in the api docs.i don't know why to use it - why not use db_query_range instead? a simple example would be really helpfulthanks!ryan scott

Adaugat in

sample example

Submitted by Integer on Joi, 07/02/2008 - 14:36.

$count = db_result(db_query("SELECT COUNT(*) FROM {table}));
$query_count = db_query("SELECT $count");
$result = pager_query("SELECT col1,col2 {table}, 10, 0, $count_query);

// do your code here... put code in $output

// display navigation
$output .= theme('pager', NULL, 10);
return $output