<?php $localhost = "localhost"; $username = "user"; // EDIT THIS $password = "pass"; // EDIT THIS $tablename = "table"; // EDIT THIS # Dont touch below now :D @mysql_connect($localhost, $username, $password) or die(mysql_error()); @mysql_select_db($tablename) or die(mysql_error()); $limit = 20; $query_count = "SELECT * FROM `tutorial`"; $result_count = mysql_query($query_count); $totalrows = mysql_num_rows($result_count); $page = $_GET['page']; if(empty($page)){ $page = 1; } $limitvalue = $page * $limit - ($limit); $query = "SELECT * FROM `tutorial` LIMIT $limitvalue, $limit"; $result = mysql_query($query) or die("Error: " . mysql_error()); if(mysql_num_rows($result) == 0){ echo("Nothing to Display!"); } $bgcolor = "#E0E0E0"; // light gray echo("<table>"); while($row = mysql_fetch_array($result)){ if ($bgcolor == "#E0E0E0"){ $bgcolor = "#FFFFFF"; }else{ $bgcolor = "#E0E0E0"; } echo("<tr bgcolor=".$bgcolor."><td>"); echo($row["name"]); echo("</td><td>"); echo($row["url"]); echo("</td></tr>"); } echo("</table>"); if($page != 1){ $pageprev = $page-1; echo("<a href=\"$PHP_SELF?page=$pageprev\">PREV</a> "); }else{ echo("PREV "); } $numofpages = $totalrows / $limit; for($i = 1; $i <= $numofpages; $i++){ if($i == $page){ echo($i." "); }else{ echo("<a href=\"$PHP_SELF?page=$i\">$i</a> "); } } if(($totalrows % $limit) != 0){ if($i == $page){ echo($i." "); }else{ echo("<a href=\"$PHP_SELF?page=$i\">$i</a> "); } } if(($totalrows - ($limit * $page)) > 0){ $pagenext = $page+1; echo("<a href=\"$PHP_SELF?page=$pagenext\">NEXT</a>"); }else{ echo("NEXT"); } mysql_free_result($result); ?>
Should work fine now.
Edited by .Matt, 16 July 2006 - 04:48 PM.