Jump to content


Photo

Get Next Record


  • Please log in to reply
1 reply to this topic

#1 lilywong

lilywong
  • Members
  • PipPipPip
  • Advanced Member
  • 56 posts

Posted 27 February 2006 - 07:43 AM

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();
}


}
?>

#2 jvrothjr

jvrothjr
  • Members
  • PipPipPip
  • Advanced Member
  • 300 posts
  • LocationOhio

Posted 03 June 2008 - 03:00 AM

use the limit function of the query.
If you understand everything you know nothing!

http://rcchjr.awardspace.com/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users