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'>[/url]</td> </tr> </table> </form> <? if ($_GET[generate]==generate) { while (!$rs->EOF) { $record = $rs->fields[RecordNo]; print $record; echo " "; $rs->MoveNext(); } } ?>