<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>
<?php
mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
@mysql_select_db($db_name) or die("Грешна база данни");
$query="SELECT * FROM kategorii ORDER BY cats ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$cats=mysql_result($result,$i,"cats");
$id_cat=mysql_result($result,$i,"id_cat");
echo "<a href=view.php?id_cat=$id_cat>$cats</a>";
$i++;
}
echo "<br>";
echo "";
echo "";
?>
</div>
</td>
<td valign="top" width="600px">
<table width="100%" border="1">
<?php
$id_cat=$_GET['id_cat'];
mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
@mysql_select_db($db_name) or die("Грешна база данни");
$pp = "10";
$total = mysql_result(mysql_query("SELECT COUNT(id_vic) FROM vicove"),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);
$query = "SELECT * FROM vicove WHERE id_cat='$id_cat' ORDER BY id_vic DESC LIMIT $limitvalue, $pp";
$result = mysql_query($query);
while($r=mysql_fetch_array($result))
{
$vic=$r[vic];
$potrebitel=$r[potrebitel];
$vreme=$r[vreme];
$email=$r;
echo "
<tr>
<td align=justify width=100% colspan=2>$vic</td>
</tr>
<tr>
<td width=100% colspan=2> </td>
</tr>";
}
?>
<table>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table>
<?php
echo 'Общо страници: '.round($numofpages).'<br>';
?>
<center>
<?php
function per_page($link, $offset) {
global $numofpages, $page;
$numofpages = round($numofpages);
$pagesstart = round($page-$offset);
$pagesend = round($page+$offset);
if ($page != "1" && round($numofpages) != "0") {
echo str_replace("%page", round($page-1), '<a href="'.$link.'"><font face="Trebuchet MS">«</font></a> ');
}
for($i = 1; $i <= $numofpages; $i++) {
if ($pagesstart <= $i && $pagesend >= $i) {
if ($i == $page) {
echo "<b>[$i]</b> ";
}
else {
echo str_replace("%page", "$i", '<a href="'.$link.'">'.$i.'</a> ');
}
}
}
if (round($numofpages) == "0") {
echo "[$i]";
}
if ($page != round($numofpages) && round($numofpages) != "0") {
echo str_replace("%page", round($page+1), '<a href="'.$link.'"><font face="Trebuchet MS">»</font></a>');
}
}
per_page("?id_cat=$id_cat&page=%page", "5");
?>[/quote]
