[PHP-DB] Pagination

Sun, 05 Dec 2004 07:17:36 -0800

It shows next and the first 10 records but will not bring up the next 10 when next is pressed.

<?php
require ('db_params.inc');
if(!$start) $start = 0;
$query2 = 'SELECT count(*) as count '
           . ' FROM `Wellington` '
           . ' WHERE`location`="Hills"';

$result2 = mysql_query($query2);
$row2 = mysql_fetch_array($result2);
$numrows = $row2['count'];
if($start > 1){
  echo "<a href=\"" . $_SERVER['PHP_SELF']. "?start=" . ($start- 10) .
       "\">Previous</a><BR>";
   }
if($numrows > ($start + 10)){
  echo "<a href=\"" . $_SERVER['PHP_SELF']. "?start=" . ($start + 10) .
      "\">Next</a><BR>";
   }


$query='SELECT * '
. ' FROM `Wellington` '
. ' WHERE`location`="Hills" ORDER BY `LotNo` ASC LIMIT ' . $start. ',10';

           $result=mysql_query($query);
           while ($row = mysql_fetch_assoc($result)) {
       $location=$row['Location'];
       $ln=$row['LotNo'];
       $price=$row['Price'];

        $listing="<html>
        <head>
        </head>
        <body>
            <table align='center'>
             <tr>
           <td>$ln</td>

              <td> $location</td>
              <td>$price</td>
             </tr></table>
             </body></html>";
      echo $listing;
}
?>

----- Original Message ----- From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 05, 2004 6:50 AM
Subject: php-db Digest 5 Dec 2004 11:50:43 -0000 Issue 2714

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to