Help with pervious/next code PLEASE

[timsharpe]

I have the below previous/next code, it works, however when you click on the other page numbers it shows the same records as the first page why?

<?php 
$category = $_GET['category']; 
$region = $_GET['region']; 
$server = "localhost"; 
$user = "user"; 
$pass = "pass"; 
$databasename = "data"; 
$db = mysql_connect($server, $user, $pass); 
    mysql_select_db($databasename,$db); 

    $sql = "SELECT * FROM businesses WHERE category='$category' AND 
region='$region' ORDER BY business_name "; 
        $query = mysql_query($sql,$db); 
        $total_results = mysql_num_rows($query); 
        $limit = "10"; //limit of archived results per page. 
        $total_pages = ceil($total_results / $limit); //total number of 

pages 
if (empty($page)) 
    { 
        $page = "1"; //default page if none is selected 
    } 
$offset = ($page - 1) * $limit; 

$query = "SELECT * FROM businesses WHERE category='$category' AND 
region='$region' ORDER BY business_name  LIMIT $offset, $limit"; 
    $result = mysql_query($query); 
//This is the start of the normal results... 

while ($row = mysql_fetch_array($result)) 
    { 
       extract($row); 
   print "<a href=\"details.php?name=$business_name\" class=dest 

title=\"$business_name\">$business_name</a><br>"; 
        } 
        mysql_close(); 


// This is the Previous/Next Navigation 
echo "<font face=Verdana size=1>"; 
echo "Pages:($total_pages)&nbsp;&nbsp;"; // total pages 
if ($page != 1) 
{ 
echo "<a 

href={$_SERVER["PHP_SELF"]}?page=1&category=$category&region=$region><< 

First</a>&nbsp;&nbsp;&nbsp;"; 
$prevpage = $page - 1; 
echo "&nbsp;<a 

href={$_SERVER['PHP_SELF']}?page=$prevpage&category=$category&region=$regi 

on><<</a>&nbsp;"; 
} 
        if ($page == $total_pages) 
            { 
                  $to = $total_pages; 
            } 
        elseif ($page == $total_pages-1) 
            { 
                  $to = $page+1; 
            } 
        elseif ($page == $total_pages-2) 
            { 
                  $to = $page+2; 
            } 
        else 
            { 
                  $to = $page+3; 
            } 
        if ($page == 1 || $page == 2 || $page == 3) 
            { 
                  $from = 1; 
            } 
        else 
            { 
                  $from = $page-3; 
            } 

for ($i = $from; $i <= $to; $i++) 

{ 
if ($i == $total_results) $to=$total_results; 
if ($i != $page) 
    { 
    echo "<a 

href={$_SERVER['PHP_SELF']}?showold=yes&page=$i&category=$category&region= 

$region>$i</a>"; 
        } 
    else 
        { 
        echo "<b><font face=Verdana size=2>[$i]</font></b>"; 
        } 
    if ($i != $total_pages) 
        echo "&nbsp;"; 
    } 
if ($page != $total_pages) 
{ 
$nextpage = $page + 1; 
echo "&nbsp;<a 

href={$_SERVER['PHP_SELF']}?page=$nextpage&category=$category&region=$regi 

on>>></a>&nbsp;"; 
echo "&nbsp;&nbsp;&nbsp;<a 

href={$_SERVER['PHP_SELF']}?page=$total_pages&category=$category&region=$r 

egion>Last >></a>"; 


} 
echo "</font>"; 

?> 
It lists a list of 10 records plus previous/next numbers as 

Thanks

Tim

[BuzzLY]

try putting at the top of your code:

$page = 1;
if (isset($_GET['page']) && is_numeric($_GET['page'])) {
    $page = $_GET['page'];
}

[timsharpe]

Ok thatw orked, however I never knew that this code displayed negative page numbers, how can I remove them?

Tim

[BuzzLY]

Whoops. Messed up the code. I'll correct it in my previous post.

I strongly recommend you use the command [FONT=courier new]error_reporting(E_ALL)[/FONT] at the top of all of your pages. This will allow you to see all errors, warnings, and notices. It makes it much easier to spot problems in your code, and forces you to write clean code.