I hate to be the bearer of bad news, but if you're using PHP and you wanted to fetch just 25 rows at a time for a
singlepage, and then fetch more when the user clicks on a NEXT button or link, you're completely out of luck. Each
httptransaction is completely separate and so you can't maintain a cursor between pages. Perhaps LIMIT would help you
here;but I've found it more useful to make sure there is a unique key for the order I'm displaying, and then say "WHERE
key> highest_key_value_on_current_page"
Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com