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 -----
