@ $db = mysql_pconnect("localhost", "mpletiko", "575414");
if (!$db)
{
echo "Spajanje na bazu nije uspjelo";
exit;
}
include ("arhiva.inc");
//echo "Upravo Vas preusmjeravamo...";
mysql_select_db("drstudent");
$query="select count(*) from Novosti";
$result=mysql_query($query);
$k = mysql_fetch_array($result);
$ukupno = $k["count(*)"];
$a = $ukupno/12;
if ($a > 1)
{
$a = floor($a)+1;
}
else $a = 1;
if (!isset($broj)) $broj=1;
$bla = ($broj-1)*12;
$query2="select * from Novosti order by datum DESC limit $bla,12";
$result2=mysql_query($query2);
$num_results2 = mysql_num_rows($result2);
echo '
|
| | | | ';
for ($i=0; $i<$num_results2; $i++)
{
$row = mysql_fetch_array($result2);
$o = ($broj-1)*10+$i+1;
arhiva($row["naslov"], $row["ID"], $row["datum"],$o);
}
echo ' |
';
if ($a>1)
{
if ($broj>1)
{
$g=$broj-1;
echo ' << ';
}
else echo "<< ";
for ($i=0; $i<$a; $i++)
{
$h = $i+1;
if ($h<>$broj)
{
echo ''.$h.' ';
}
else echo $h.' ';
}
if ($broj< $a)
{
$j=$broj+1;
echo '>>';
}
else echo ">>";
}
?>
|
|