קח קוד, זה בטוח יעזור לך יותר..
PHP קוד:
$page = (int) $_GET['page'];
if($page < 1 OR !$page)
{
$page = 1;
}
$per_page = 6; // results per page
$start = $per_page * ($page-1);
$query = mysql_query("SELECT * FROM `blat` ORDER BY `blat2` DESC LIMIT ".$start.", ".$per_page." ");
while($info = mysql_fetch_assoc($query))
{
//code...
}
//הצגת הדפים
$q = mysql_num_rows(mysql_query("SELECT * FROM `blat`"));
$total_pages=ceil($q / $per_page);
$pages = array();
for($i = 1; $i <= $total_pages; $i++)
{
if($i == $page)
{
$pages[] = '<b>' . $i . '</b>';
}
else
{
$pages[] = "<a href = \"page.php?page=$i\">$i</a>";
}
}
echo implode(', ' , $pages);