вывожу данные в виде таблицы
<?php
function tovary_all() {
$page_content = '';
db_set_active('test');
$query="SELECT productid, name , price FROM product ORDER BY name ASC";
$result=pg_query($query);
$num_rows=pg_num_rows($result);
if ($num_rows>0)
{
$resultHTML = "<table>\n<tr>\n";
$field_count = pg_num_fields($result);
for ($i=0; $i < $field_count; $i++)
{
$field_name = pg_field_name($result, $i);
$resultHTML .= "<th>$field_name</th>";
} // end for
$resultHTML .= "</tr>\n";
while (
$row = pg_fetch_row($result)){
$resultHTML .= "<tr>\n";
for ($i = 0; $i < $field_count; $i++)
{
// print_r($row);
$field_name = pg_field_name($result, $i);
if ($field_name=='name')
$resultHTML .= "<td><a href=#>".htmlentities($row[$i], ENT_COMPAT, 'UTF-8')."</a></td>";
else
$resultHTML .= "<td>".htmlentities($row[$i])."</td>";
}
$resultHTML .= "</tr>\n";
}
$resultHTML .= "</table>";
$page_content=$resultHTML;
if (
$page_content == '') {
$page_content = "пусто";
}
db_set_active('default');
return $page_content;
}
}
?>
не пойму как прикрутить pager_query/theme_pager.