|
|
|
'1' AND tisk='1' ORDER by datum DESC LIMIT $pageNum10,$rowsPerPage;";
$sOutputTable = '';
$i=false;
$rs = mysql_query($sSQL) or die (mysql_error());
while ($row = mysql_fetch_array($rs)):
if ($row['cesta']=="")
{
$odkaz="";
$odkaz_konec="";
}
else
{
$odkaz="";
$odkaz_konec="";
}
if ($row["cervena"]=="A")
{
print "";
}
else
{
print "";
}
if ($row["datum"]<>'0000-00-00')
{
print "".date("d.m.Y", strtotime($row["datum"]))."";
}
print " ".$row["obsah"]." ";
/*
print "";
if ($row["datum"]<>'0000-00-00')
{
print "".date("d.m.Y", strtotime($row["datum"]))."";
}
print "".$row["obsah"]." ";
*/
endwhile;
mysql_free_result($rs);
?>
'1' AND tisk='1';";
$result = mysql_query($query) or die('Error, query failed2');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows']-$rowsPerPage;
$maxPage = ceil($numrows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];
if ($pageNum > 1)
{
$page = $pageNum-1;
$prev = " [Předchozí] ";
$first = " [První] ";
}
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 = " [Další] ";
$last = " [Poslední] ";
}
else
{
$next = ' '; // we're on the last page, don't print next link
$last = ' '; // nor the last page link
}
echo "
";
echo "".$first . $prev ." Strana $pageNum z $maxPage " . $next . $last."";
?>
|
|
|
|
|
|
 |
