Hi, this is my code:
db_set_active('db1'); $query = "SELECT * from {keywords2} order by keyword_id desc"; $pager_num = 0; $res = pager_query($query,20,$pager_num,NULL);
while ($data = db_fetch_array($res)) { $out['table'] .= '<TR>LINEX</TR>'; }
db_set_active('default'); $out['pager'] = theme('pager',NULL,20, $pager_num); $_SESSION['page'] = (isset($_GET['page'])) ? $_GET['page'] : 0; return theme_render_template(drupal_get_path('module','keywords')."/theme/listpage.tpl.php",$out);
My problem is that theme('pager',....) return me a code for 1171 pages but my data arrive only to 837pages.
Where is the error ? keywords2 is a shared table.
M.