Pagination

[adammc]

Hi folks,

Can anyone help me with this pagination code, the next prev links are not working 🙁

<?php

$limit          = 10;               
$query_count    = "SELECT count(*) FROM job_post";    
$result_count   = mysql_query($query_count);    
$totalrows      = mysql_num_rows($result_count);


$limitvalue = $page * $limit - ($limit);
$query  = "SELECT * FROM job_post LIMIT $limitvalue, $limit";        
$result = mysql_query($query) or die("Error: " . mysql_error());


$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["position"]);
echo("</td><td>");
echo($row["JobIn"]);
echo("</td></tr>");
}

echo("</table>");

if($page != 1){
    $pageprev = $page--;

    echo("<a href=\"$PHP_SELF&page=$pageprev\">PREV".$limit."</a> ");
}else{
    echo("PREV".$limit." ");
}

$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++;

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

mysql_free_result($result);

?> 

[tuf-web_co_uk]

ok firstly you should get a sql syntax error, saying something like this...

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10, 10' at line 1

$limitvalue = $page $limit - ($limit);
$query = "SELECT FROM job_post LIMIT $limitvalue, $limit";

$limit has been set to 10, but $page hasnt been set, therefore

$page $limit - ($limit) is the same as saying 0 10 - 10, because of bodmas this is (0 * 10) - 10, thats why you get -10 in the sql command.

before you run the above query place this code

<?php
if (!empty($_GET['page'])) {
	$page = $_GET['page'];
}
else {
	$page = 1;
}
?>

as for the previous and next links.

for some reason the $page-- and $page++ isnt working, so just change them to $page - 1 and $page + 1

$pageprev = $page - 1;
$pageprev = $page + 1;

and in the code for your PREV link you have missed out a ? after $PHP_SELF

echo("<a href=\"$PHP_SELF&page=$pageprev\">PREV".$limit."</a> ");
should be
echo("<a href=\"$PHP_SELF?&page=$pageprev\">PREV".$limit."</a> ");

hth