<?
include"conf.php";
$pp = "5";
//клипчета на страница
$table = "clips";
echo '<meta http-equiv="content-type" content="text/html; charset=windows-1251">';
$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table "),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);
echo"<table align=\"left\" border=\"0\">";
$cathegory=$_GET['kategoria'];
$i="0";
$nared="6";
$query="SELECT * FROM $table WHERE `kategoria`='".$cathegory."' ";
$result=mysql_query($query);
while ( $r = mysql_fetch_array( $result ) or die (mysql_error())){
$i++;
$width=ceil(100/$nared);
$ime=$r[ime];
$pic=$r[pic];
$klik=$r[klik];
$url=$r[url];
if (strlen($ime)>16)
{$t='...';}
$ime = substr($ime,0,16);
$kat = $r[kategoria];
echo"<td width=\"130\" align=\"center\" border=\"1\" background=\"images/b.gif\">
<a href=\"view.php?id=$r[id]\" onmouseover=\"return overlib('$r[ime]')\" onmouseout=\"return nd();\"><img src=\"$pic\" border=\"0\" width=\"120\" height=\"90\"></div><br><b>$ime$t</a>";
if($kat==""){
echo"<br>Гледан : $klik пъти
<br>Свали : <a href=\"$url\">От Тук</a>
<br>Няма категория<br>";
}else{ echo"
<br>Гледан : $klik пъти
<br>Свали : <a href=\"$url\">От Тук</a>
<br>Категория : <a href=\"cat.php?kategoria=$r[kategoria]\"><b>$kat</a><br>";}
if ($i==$nared)
{
echo "</tr>
<tr>";
$i=0;
}
}
echo"</table>"; ?>