Странициране на този код

[webdefender]

<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<?php
$host = "localhost";
$username = "ьььььь";
$password = "";
$database = "фвьььь";
$connect = mysql_connect($host, $username, $password)
or die("Не може да свърже с базата данни");
mysql_select_db($database, $connect)
or die("Не може да селектира базата данни");
mysql_query("SET CHARACTER SET cp1251");
$category = 1;
if(isset($_GET['category']) and is_numeric($_GET['category'])) {
$category = intval($_GET['category']);
}	
$result = mysql_query("SELECT title,author,price,image FROM books WHERE genID = '".$category."'")
or die("Не може да изпълни заявката");

if(mysql_num_rows($result) > 0) {
while($row = mysql_fetch_array($result)) {
echo'<img src='.$row['image'].' width="160" height="180" > </br>';	
echo $row['title']."<br />";
echo $row['author']."<br />";
echo $row['price']."<br />";
} 
} else {
echo "Няма резултати в тази категория.";
}

?>

този код е с система за категории как мога да му сложа странициране да показва по 5 резултата само

 

[bankera1990]

<?php 
$host = "localhost"; 
$username = "ьььььь"; 
$password = ""; 
$database = "фвьььь"; 
$connect = mysql_connect($host, $username, $password) 
or die("Не може да свърже с базата данни"); 
mysql_select_db($database, $connect) 
or die("Не може да селектира базата данни"); 
mysql_query("SET CHARACTER SET cp1251"); 
$category = 1; 
if(isset($_GET['category']) and is_numeric($_GET['category'])) { 
$category = intval($_GET['category']); 
}
$page = $_GET['page'];
if ($page == 0 || $page == NULL || $page < 0)
{
    $page = 1;
}
$pp = 10;
$start = ($page*$pp) - $pp;
$query = mysql_query("SELECT title,author,price,image FROM books WHERE genID = '".$category."'") or die (mysql_error());
$broi = mysql_num_rows($query);
$total = ceil($broi/$pp);    
$result = mysql_query("SELECT title,author,price,image FROM books WHERE genID = '".$category."'") 
or die("Не може да изпълни заявката"); 

if(mysql_num_rows($result) > 0) { 
while($row = mysql_fetch_array($result)) { 
echo'<img src='.$row['image'].' width="160" height="180" > </br>';    
echo $row['title']."<br />"; 
echo $row['author']."<br />"; 
echo $row['price']."<br />"; 
}
echo "<br /><center>"; 
if ($page > 1) { 
$prev = ($page - 1); 
echo "<a href=\"?page=$prev\" class='pages'>предишна</a> "; 
} 
else echo ""; 

if (!$page or ($page > $total)) { 
$page="1"; 
} 

if ($total < 10) { 
for($i=1 ; $i<=$total ; $i++) { 
if ( ($page)==$i ) { 
echo "<a class='pagesactive'> $i </a> "; 
} 
else { 
echo "<a href=\"?page=".$i."\" class='pages'> ".$i." </a> "; 
} 
} 
} 
else { 
for($i=1 ; $i<=3 ; $i++) { 
if ( ($page)==$i ) { 
echo "<a class='pagesactive'> $i </a> "; 
} 
else { 
echo "<a href=\"?page=".$i."\" class='pages'> ".$i." </a> "; 
} 
} 

if ($page <= 3) { 
if ($page == 3) echo " <a href=\"?page=4\" class='pages'> 4 </a> "; 
echo " <a class='pages'> ... </a> "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?page=".$i."\" class='pages'> ".$i."</a> "; 
} 
if ($page == 5) $parva.= " <a href=\"?page=4\" class='pages'> 4 </a> "; 

if ( ($page == 4) or ($page == 5) ) { 
for ($i=$page; $i<=$page+1; $i++) { 
if ($page == $i) echo "<a class='pagesactive'> $i </a> "; 
else echo "<a href=\"?page=".$i."\" class='pages'> ".$i." </a> "; 
} 
echo " <a class='pages'> ... </a> "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?page=".$i."\" class='pages'> ".$i." </a> "; 
} 

if ( ($page > 5) and ($page < ($total - 4)) ) { 
echo " <a class='pages'> ... </a> "; 
for ($i=$page-1; $i<=$page+1; $i++) { 
if ($page == $i) echo "<a class='pagesactive'> $i </a> "; 
else echo "<a href=\"?page=".$i."\" class='pages'> ".$i." </a> "; 
} 
echo " <a class='pagesactive'> ... </a> "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?page=".$i."\" class='pages'> ".$i." </a> "; 
} 

if ( $page > ($total - 5) ) { 
echo " <a class='pages'> ... </a> "; 
for ($i=$total-5; $i<=$total; $i++) { 
if ($page == $i) echo "<a class='pagesactive'> $i </a> "; 
else echo "<a href=\"?page=".$i."\" class='pages'> ".$i." </a> "; 
} 
} 
} 

if ($page < $total) { 
$next = ($page + 1); 
echo "<a href=\"?page=$next\" class='pages'>следваща</a>"; 
} 
print "<br /> Страница $page от $total</center>";

 
} else { 
echo "Няма резултати в тази категория."; 
} 

?>