Pixel2Life

<?php

    if($_GET['page']) // Is page defined?

    {

        $page = $_GET['page']; // Set to the page defined

    }else{

        $page = 1; // Set to default page 1

    }

$max = 10; // Set maximum to 10

 

$cur = (($page * $max) - $max); // Work out what results to show

 

$getdata = mysql_query("SELECT * FROM `table` ORDER BY `id` DESC LIMIT $cur, $max") or die(mysql_error()); // select the results

$data = mysql_fetch_array($getdata); // get the data

 

$counttotal = mysql_query("SELECT * FROM `table` ") or die(mysql_error()); // select all records        

$counttotal = mysql_num_rows($counttotal); // count records

 

$total_pages = ceil($counttotal / $max); // dive the total, by the maximum results to show 

 

if($page > 1){ // is the page number more than 1?

                $prev = ($page - 1); // if so, do the following. take 1 away from the current page number

                echo '<a href="?page=' . $prev . '">« Previous</a>'; // echo a previous page link

                }

 

for($i = 1; $i <= $total_pages; $i++) // for each page number

                {

                    if($page == $i) // if this page were about to echo = the current page

                        {

                            echo'<b>' . $i .'</b> '; // echo the page number bold

                                } else {

                            echo '<a href="?page=' . $i . '">' . $i . '</a> '; // echo a link to the page

                        }

                }

 

if($page < $total_pages){ // is there a next page?

                    $next = ($page + 1); // if so, add 1 to the current

                echo '<a href="?page=' . $next . '">Next »</a>'; // echo the next page link

                    } 

?> // end php script