Syntax :pager_query($query, $limit = 10, $element = 0, $count_query = NULL)
Table format Pager :
if you want to display the data as a table format, you can use the following example:
/**To get the records, first we need to have a query for total records. I am taking an example of node table records.**/$sql_count = "SELECT count(*) FROM node"; $sql = pager_query("SELECT * FROM node",5,0,$sql_count); //5 - limited pages to show $nodeContent = array(); while($row = db_fetch_object($sql)){ $createdDate = date('jS M, Y',$row->created); $nodeContent[] = array( $row->nid, $row->title, $createdDate); } // to set the table header titles $tableHeader = array('Nid','Title','Date'); // to get the table format $output .= theme('table', $tableHeader, $nodeContent); // get the pager $output .= theme('pager', NULL, 5, 0); return $output;
