Gadgets Update :: Be smart than gadgets geek : Learn How 2

Posted by

Addbucket » Gadgets

$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...

". "

"; } ?>