Gadgets Update :: Be smart than gadgets geek : Learn How 2
$sql = mysql_query("SELECT * FROM main WHERE ap='y' and Key1='Gadgets' or Key2='Gadgets' ORDER BY No DESC"); $nr = mysql_num_rows($sql); if (isset($_GET['pn'])) { $pn = preg_replace('#[^0-9]#i', '', $_GET['pn']); } else { $pn = 1; } $itemsPerPage = 7; $lastPage = ceil($nr / $itemsPerPage); if ($pn < 1) { $pn = 1; } else if ($pn > $lastPage) { $pn = $lastPage; } $centerPages = ""; $sub1 = $pn - 1; $sub2 = $pn - 2; $add1 = $pn + 1; $add2 = $pn + 2; if ($pn == 1) { $centerPages .= ' ' . $pn . ' '; $centerPages .= ' ' . $add1 . ' '; } else if ($pn == $lastPage) { $centerPages .= ' ' . $sub1 . ' '; $centerPages .= ' ' . $pn . ' '; } else if ($pn > 2 && $pn < ($lastPage - 1)) { $centerPages .= ' ' . $sub2 . ' '; $centerPages .= ' ' . $sub1 . ' '; $centerPages .= ' ' . $pn . ' '; $centerPages .= ' ' . $add1 . ' '; $centerPages .= ' ' . $add2 . ' '; } else if ($pn > 1 && $pn < $lastPage) { $centerPages .= ' ' . $sub1 . ' '; $centerPages .= ' ' . $pn . ' '; $centerPages .= ' ' . $add1 . ' '; } $limit = 'LIMIT ' .($pn - 1) * $itemsPerPage .',' .$itemsPerPage; $sql2 = mysql_query("SELECT * FROM main WHERE ap='y' and Key1='Gadgets' or Key2='Gadgets' ORDER BY No DESC $limit"); $paginationDisplay = ""; if ($lastPage != "1"){ $paginationDisplay .= 'Page ' . $pn . ' of ' . $lastPage. ' '; if ($pn != 1) { $previous = $pn - 1; $paginationDisplay .= ' Back '; } $paginationDisplay .= '' . $centerPages . ''; if ($pn != $lastPage) { $nextPage = $pn + 1; $paginationDisplay .= ' Next '; } } while($row = mysql_fetch_array($sql2)){ echo "
{$row['Title']}
". "Posted on: {$row['Date']}". "{$row['SortBody']} Read more...
". ""; } ?>