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 single page, and then fetch more when the user clicks on 
a NEXT button or link, you're completely out of luck.  Each http transaction 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

Reply via email to