Received: from mc-qout2.whowhere.com (nytoday.whowhere.com [209.1.236.38]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id e9UIx8C46667 for ; Mon, 30 Oct 2000 13:59:08 -0500 (EST) (envelope-from kparker@eudoramail.com) Received: from Unknown/Local ([?.?.?.?]) by shared1-mail.whowhere.com; Mon Oct 30 10:58:52 2000 To: pgsql-sql@postgresql.org Date: Mon, 30 Oct 2000 10:58:52 -0800 From: "K Parker" Message-ID: Mime-Version: 1.0 X-Sent-Mail: off Reply-To: kparker@eudoramail.com X-Mailer: MailCity Service Subject: Re: fetching rows X-Sender-Ip: 209.191.185.54 Organization: QUALCOMM Eudora Web-Mail (http://www.eudoramail.com:80) Content-Type: text/plain; charset=us-ascii Content-Language: en Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/17 X-Sequence-Number: 17 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