select * from table_name limit 1; or limit 2,1; I hope this helps a bit? Simon
-----Original Message----- From: Beauford [mailto:beauford.2003@;rogers.com] Sent: 12 November 2002 15:04 To: [EMAIL PROTECTED] Subject: Scrolling Databases Hi, I have created a contact database using Mysql and want to be able to scroll back and forth through the database. Even after I have done a search and found a record, I want to be able to scroll back or forth from that point on. I am using PHP4 to display the results. This may be something easy to do, but I have not found any documentation on it, and with my newbie skills at both Mysql and PHP, I haven't been able to put it together. Can someone point me in the right direction. TIA --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php