<?php
$broinastranica = 24;
$pageNum = 1;
$id=(int)$_GET['cat_id'];
if(isset($_GET['page']))
{
$pageNum = (int)$_GET['page'];
}
if($pageNum>0)
{
$redove = ($pageNum - 1) * $broinastranica;
if(isset($id) && $id>0 )
{
$sql2=mysql_fetch_assoc(mysql_query("SELECT * FROM `categories` WHERE `id`='".$id."'"));
$sql=mysql_query("SELECT * FROM `templates` WHERE `type`='PSD' and `category`='".$sql2['category']."' LIMIT $redove, $broinastranica");
}
else
{
$sql=mysql_query("SELECT * FROM `templates` WHERE `type`='PSD' LIMIT $redove, $broinastranica");
}
if($l>0 or $l<0)
{
if(mysql_num_rows($sql))
{
header('location:index.php');
}
}
echo'<div style="width:650px;height:525px;">';
while($row=mysql_fetch_assoc($sql))
{
echo '<table width="100" style="float:left"><tr><td><a href="ajax.php?id='.$row['id'].'&width=300" class="jTip" id="one" name="Preview:"><img src="admin/files/thumbnail/'.$row['pic'].'" border=1 width="100" height="100" alt=""/></a></td></tr><tr><td align="center"><a href="view_tpl.php?id='.$row['id'].'">
<font color="#555555">Преглед</font></a></td></tr></table>';
}
echo'</div>';
if($id>0)
{
$query = "SELECT COUNT(id) AS numrows FROM `portfolio`.`templates` WHERE category='".$id."' and TYPE='PSD'";
}
else
{
$query = "SELECT COUNT(id) AS numrows FROM templates WHERE TYPE='PSD'";
}
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= " $page ";
}
else
{
$nomeranastranici .= " <b><a href=\"$self?page=$page\"><font color='#333333'>$page</font></a> </b>";
}
}
echo $nomeranastranici;
}
else
{
header('location:index.php');
}
?>
