<?
$pg = isset($HTTP_GET_VARS['pg']) ? $pg = (int) $HTTP_GET_VARS['pg'] : 1;
?>
<table width='100%' border='0' cellspacing='1'>
<tr>
   <td>

      <table border="0" cellpadding="4" cellspacing="1" width="100%">
<?
      $resultsPerPage = 50;
      $maxPageNumbers = 10;
      $rows           = $database->countUsers();
      $countPages     = (($rows/$resultsPerPage)>1) ? ($rows/$resultsPerPage) : 1;
      $startPage      = (($pg+$maxPageNumbers) <= $countPages) ? $pg : ($countPages - $maxPageNumbers);
      $startPage      = ($startPage <= 1) ? 0 : $startPage;
      if( (($rows % $resultsPerPage) > 0)&&($countPages>1) ){
$countPages = $countPages+1;
}

      $result = $database->query (SELECT * FROM USERS WHERE CLUE = 1);

        while($fc_item = $database->fetchArray($result)) {
         echo "<tr>\n";
          echo "<td><a href='pagina.php'>".$fc_item["nome"]."</a></td>\n";
          echo "<td><a href='pagina.php'>".$fc_item["descricao"]."</a></td>\n";
         echo "</tr>\n";
      }
      if($countPages > 1){
         echo "<tr><td align='center' colspan='3'>\n";
          echo "<span class='fg2'>";
         echo ($pg > 0) ? "<a href='pagina_lista.php?pg=".($pg-1)."'>anterior</a>" : "";

         for($i= $startPage  ;( ($i<=$countPages)&&($i<=$startPage+$maxPageNumbers) );$i++){
            echo ($pg != $i) ? "<a href=' pagina_lista.php?pg=".($i)."'>".$i."</a>|" : $i;
         }
         echo ($pg < $countPages) ? "<a href=' pagina_lista.php?pg=".($pg+1)."'>próximo</a>" : "";
         echo "</spam>\n";
         echo "</td></tr>\n";
      }
?>
      </table>
</td></tr>
</table>