Small pagination problem

[kbloem]

Hmm i can't figure this out...

 

Below you see my code. I have 8 results from the query and i have the pegination set to max 2 values. It has 8 result so it devides them into 4 pages. But all the results are on the first page so the second third and fourth page are empty. Why is that?

 

 

 

    <?php

 

    if (isset($_POST['model_zoeken']))

    {

    $con = mysql_connect("localhost","admin","");

    if (!$con)

    {

    die('Could not connect: ' . mysql_error());

    }

 

    if (!(isset($pagenum)))

    {

    $pagenum = 1;

    }

 

    mysql_select_db("produkten", $con);

 

    $data = mysql_query("SELECT * FROM eigenschappen") or die(mysql_error());

 

 

 

    $rows = mysql_num_rows($qry);

 

    $page_rows = 2;

 

    $last = ceil($rows/$page_rows);

 

    if ($pagenum < 1)

    {

    $pagenum = 1;

    }

    elseif ($pagenum > $last)

    {

    $pagenum = $last;

    }

 

    $max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows;

 

    $data_p = mysql_query("SELECT * FROM eigenschappen $max") or die(mysql_error());

     

    $qry = "SELECT * FROM eigenschappen WHERE 1=1";

        if (isset($_POST['prod_name']) && trim($_POST['prod_name']) != "") {

        $qry .= " AND prod_name='" . mysql_real_escape_string($_POST['prod_name']). "'";

        }

     

        "'";

        }

             

        $result = mysql_query($qry) or die(mysql_error());

     

        $teller = 0;

        $rijen = 0;

     

        echo '<table border="0"><tr>';

     

        while($row = mysql_fetch_array($result))

        {

            echo'

                <td width="160" align="center">

                <a href="'.$row['website'].'"></a><img src="'.$row['prod_img'].'">

                </td>

                <td width="165" valign="top"><br /><br />Name:

                    '.$row['prod_name'].'<br/><br/>Website: <a href="'.$row['website'].'" target="_blank">'.$row['website_naam'].'</a>

                </td>'

            ;

            $teller = $teller + 1;

            $rijen = $rijen + 1;

            if ($teller == 3 || $rijen == 3){

                echo "</tr><tr>";

                $rijen = 0;

                $teller = 0;

                }

        }

        echo '</tr></table>';

     

        echo '<br />';

        echo " --Page $pagenum of $last-- <p>";

     

        if ($pagenum == 1)

        {

        }

        else

        {

        echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=1'> <<-First</a> ";

        echo " ";

        $previous = $pagenum-1;

        echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'> <-Previous</a> ";

        }

 

        echo " ---- ";

 

        if ($pagenum == $last)

        {

        }

        else {

        $next = $pagenum+1;

        echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next'>Next -></a> ";

        echo " ";

        echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last ->></a> ";

        }

     

    }

    ?>

[dreamwest]

heres a good example:

 

http://www.wizecho.com/nav=extra&s=bits#3