You have to do your original request like this:

<?php // Your stuff above

$query = "MY SELECT STATEMENT"; $count_query = "" ; // This is optional, do it if your select query is very complex

$limit = 12242342; // Some integer // 0 here is the $element var, needed only if you put more than one pager on the same page $result = pager_query($query, $limit, 0, $count_query /* Leave this to null if you dont use a count_query */);

// Then here treat and display your results

// Then:

// The 0 is the $element above $form['pager'] = array( '#type' = 'markup', // Don't forget this line, else you wont have your pager displayed :) '#value' => theme('pager', array() /* Leave a null array here just work */, $limit, 0, array() /* Just put an empty array or ommit the parameter */) );

// Continue your stuff under ?>

On jeu, 2008-08-07 at 11:07 +0200, Fred Jones wrote:

I have a custom SQL search and I use pager_query which works nicely. But how do I get the paging links to come up? I tried this:

$form['pager'] = array(
	'#value' => theme('pager', NULL, 10, 0)
);

which I see in other modules, but nothing happens. To clarify, this code:

$form[] = array(
	'#value' => theme('table', array('Name'), my_module_run_search())
);

generates the search results, and in my_module_run_search() I call pager_query.

I am also wondering how the page=1 from the URL gets transferred into pager_query, because if I manually add it to the URL, I still get the first page.

Thanks for any pointers!