Get Next Record

[lilywong]

How to get the next record for each time the icon is pressed ?
the database like
1000
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
for example, the first record showed is 1000, when i press the icon, it should only show 1000, when i press the icon second time, it shold only display 1550, the third time i pressed it should only show 1551. (ie. click one time, and the running number will increase one )
however my code will show all the records from the first until the end, what's the problem ?

below is the codes.
===================================================================
$sql = "SELECT * FROM record";
$rs = $db->Execute($sql);

$record = $rs->fields[RecordNo];
$total = $rs->RecordCount();
$i = 0;
?>

<form method='post' action='index.php'>

<table width='200' border=1>
<tr><td width='100'>Current Number</td>
<td width='100'><?=$record?></td>
<tr>

<tr>
<td colspan='2' align='right'>
<a href='index.php?generate=generate'><img src='images/mouse.gif' border='0' title='GENERATE'></a></td>
</tr>

</table>
</form>
<?
if ($_GET[generate]==generate)
{
while (!$rs->EOF)
{
$record = $rs->fields[RecordNo];
print $record;
echo "<br>";
$rs->MoveNext();
}


}
?>

[jvrothjr]

use the limit function of the query.