Pagination Issue

[Manat]

Hello all,

I have a search page, it does a very basic search, but the pagination doesn't work properly.

If I am on Page 2, it shows Page 1 as the current page and not as a link, and page 2 shows as a link when im already at page two.

I would apreciate any help.

Here is the relevant code:

$get_data = mysql_query("SELECT keywords.*, Product.* FROM keywords, Product WHERE keywords.keyword='$phrase' AND keywords.sku = Product.SKU") or die(mysql_error()); 
$sku_use=0; 
$count=0;
while ($row=mysql_fetch_array($get_data)) 
    { 

if ($row[sku] != $sku_use) 
    {$count++; }
}

$count is to count how many results, of course.

//Pagination step 1 Begins
    $limit = 10;                

    $totalrows = $count; 

if(empty($page)){ 
    $page = 1; 
}
$limitvalue = $page * $limit - ($limit); 

//Pagination step 1 Ends

$get_entries = mysql_query("SELECT keywords.*, Product.*, Price_Range.* FROM keywords, Product, Price_Range WHERE keywords.keyword='$phrase' AND keywords.sku = Product.SKU AND Product.Price_Range_ID  = Price_Range.Price_Range_ID ORDER BY Price_Range.rangeID ASC LIMIT $limitvalue, $limit") or die(mysql_error());

//Pagination step 2 Begins
    if($page != 1){ 
        $pageprev = $page--; 

    echo("<a href=\"./key.php?page=$pageprev&phrase=$phrase\">PREV ".$limit."</a>&nbsp&nbsp;"); 
}else{ 
    echo("PREV".$limit."&nbsp;"); 
} 

$numofpages = $totalrows / $limit; 

for($i = 1; $i <= $numofpages; $i++){ 
    if($i == $page){ 
        echo($i."&nbsp;"); 
    }else{ 
        echo("<a href=\"$PHP_SELF?page=$i&phrase=$phrase\">$i</a>&nbsp;"); 
    } 
} 


if(($totalrows % $limit) != 0){ 
    if($i == $page){ 
        echo($i."&nbsp;"); 
    }else{ 
        echo("<a href=\"$PHP_SELF?page=$i&phrase=$phrase\">$i</a>&nbsp;"); 
    } 
} 

if(($totalrows - ($limit * $page)) > 0){ 
    $pagenext = $page++; 

    echo("<a href=\"$PHP_SELF?page=$pagenext&phrase=$phrase\">NEXT ".$limit."</a>"); 
}else{ 
    echo("NEXT".$limit); 
} 

//Pagination step 2 Ends

Would anyone know what is going on? Why is the wrong page being displayed as the correct page?

Thx
MK

[dalecosp]

Have you tried setting the initial variables to one instead of zero? (count, etc...)

Jus' curious. Sometimes I forget I'm starting with zero when I do pagination....

[Manat]

If I set $count to 1, then when I say, found 12 Results, it will say 13, which won't be the right value.
But I tried it and it didn't help.

When I am on Page 2, $page is equal to 2 and $i is 2, but the pagination navigation links says im on page 1, because I cannot click on 1, but I can click on 2.

Plz help!!!

thx
MK

[Manat]

Anyone? I would apreciate any help

[dcav]

http://www.phpbuilder.com/board/showthread.php?s=&postid=10539226#post10539226

try this out

[dcav]

http://www.phpbuilder.com/board/showthread.php?s=&postid=10539226#post10539226

try this out