trouble with pagination

Hi guys,

i have a pagination script and showing the first 10 results is going great. but when i click to page 2 it does not work. i think its because of the POST / GET things

Some can see whats wrong?

my form

[php]















Kies een functiegebied
lasser
Mecanicien
electricien
chauffeur


Kies Regio
Oost-Vlaanderen
West-Vlaanderen


kies opleidingsniveau
A2
A3
PROF. Bachelor

[/php]

the pagination code

[php]$tableName=“kandidatengoed”;
$targetpage = “goedgoed.php”;
$limit = 10;

$query = "SELECT COUNT(*) as num FROM $tableName WHERE voorkeursfunctiegebied1='".$_POST['functie']."' AND provincie='" . $_POST['provincie'] . "'";

$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];

$stages = 3;
$page = mysql_escape_string($_GET['page']);
if($page){
    $start = ($page - 1) * $limit;
}else{
    $start = 0;    
    }    

// Get page data
$query1 = "SELECT * FROM kandidatengoed WHERE voorkeursfunctiegebied1='".$_POST['functie']."' AND provincie='" . $_POST['provincie'] . "' LIMIT $start, $limit";
$result = mysql_query($query1);

// Initial page num setup
if ($page == 0){$page = 1;}
$prev = $page - 1;    
$next = $page + 1;                            
$lastpage = ceil($total_pages/$limit);        
$LastPagem1 = $lastpage - 1;                    


$paginate = '';
if($lastpage > 1)
{    




    $paginate .= "<div class='paginate'>";
    // Previous
    if ($page > 1){
        $paginate.= "<a href='$targetpage?page=$prev'>previous</a>";
    }else{
        $paginate.= "<span class='disabled'>previous</span>";    }
        

    
    // Pages    
    if ($lastpage < 7 + ($stages * 2))    // Not enough pages to breaking it up
    {    
        for ($counter = 1; $counter <= $lastpage; $counter++)
        {
            if ($counter == $page){
                $paginate.= "<span class='current'>$counter</span>";
            }else{
                $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    
        }
    }
    elseif($lastpage > 5 + ($stages * 2))    // Enough pages to hide a few?
    {
        // Beginning only hide later pages
        if($page < 1 + ($stages * 2))        
        {
            for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
            {
                if ($counter == $page){
                    $paginate.= "<span class='current'>$counter</span>";
                }else{
                    $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    
            }
            $paginate.= "...";
            $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
            $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";        
        }
        // Middle hide some front and some back
        elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
        {
            $paginate.= "<a href='$targetpage?page=1'>1</a>";
            $paginate.= "<a href='$targetpage?page=2'>2</a>";
            $paginate.= "...";
            for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
            {
                if ($counter == $page){
                    $paginate.= "<span class='current'>$counter</span>";
                }else{
                    $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    
            }
            $paginate.= "...";
            $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
            $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";        
        }
        // End only hide early pages
        else
        {
            $paginate.= "<a href='$targetpage?page=1'>1</a>";
            $paginate.= "<a href='$targetpage?page=2'>2</a>";
            $paginate.= "...";
            for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
            {
                if ($counter == $page){
                    $paginate.= "<span class='current'>$counter</span>";
                }else{
                    $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    
            }
        }
    }
                
            // Next
    if ($page < $counter - 1){
        $paginate.= "<a href='$targetpage?page=$next'>next</a>";
    }else{
        $paginate.= "<span class='disabled'>next</span>";
        }
        
    $paginate.= "</div>";        

}

echo "

";
    while($row = mysql_fetch_array($result))
    {
    
    
    echo "<tr>";

echo “

”;
echo “”;
echo “”;
echo “”;
echo “”;
echo “”;
echo “”;
    }
echo "</table>";

if (!empty($_POST[‘functie’]) && !empty($_POST[‘provincie’])){
// Uitvoeren van functie en provincie
} elseif (!empty($_POST[‘functie’])){
// Uitvoeren van functie
} elseif (!empty($_POST[‘provincie’])){
// Uitvoeren van provincie
} else {
// Uitvoeren van geen van beide
}

[/php]

Voornaam opleidingsniveau provincie Functiegebied Ervaring woonplaats
” . $row[‘voornaam’] . “” . $row[‘opleidingsniveau’] . “” . $row[‘provincie’] . “” . $row[‘voorkeursfunctiegebied1’] . “” . $row[‘ervaring’] . “” . $row[‘woonplaats’] . “

I don’t have time to review your code right now but perhaps this thread may help you

http://www.phphelp.com/forum/index.php?topic=19954.0

its a different problem. when i click page 2 or 3 he dont display the result that the user is searching for.

i think when clickin next page or other page he dont remember the vaulues of the search form. so he displays the whole table.

how can i fix this?

i just cant see the problem :-\

Sponsor our Newsletter | Privacy Policy | Terms of Service