|
".$row['nome'].""; }
else
{ $formazione = $row['nome']; }
echo "\t\t\t\t\t\t\t".
"\t\t\t\t\t\t\t".
"\t\t\t\t\t\t\t".charactersfill($row['commenti'],120)."
".
"\t\t\t\t\t\t\t";
}
// how many rows we have in database
$query = $querystart;
$result = mysql_query($query) or die('Error, query 2 failed');
while($row = mysql_fetch_array($result))
{
$numrows++;
}
// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);
// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nav .= " $page "; // no need to create a link to current page
}
else
{
$nav .= " $page ";
}
}
// creating previous and next link
// plus the link to go straight to
// the first and last page
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " [ precedente ] ";
$first = " [ inizio ] ";
}
else
{
$prev = ' '; // we're on page one, don't print previous link
$first = ' '; // nor the first page link
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " [ seguente ] ";
$last = " [ fine ] ";
}
else
{
$next = ' '; // we're on the last page, don't print next link
$last = ' '; // nor the last page link
}
// print the navigation link
echo "
".$first.$prev.$nav.$next.$last."";
?>
|