| From: | "K Parker" <kparker(at)eudoramail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: fetching rows |
| Date: | 2000-10-30 18:58:52 |
| Message-ID: | NOBNBJMODFMJBAAA@shared1-mail.whowhere.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Hoffmann | 2000-10-30 19:02:20 | Re: fetching rows |
| Previous Message | Peter Eisentraut | 2000-10-30 16:44:59 | Re: Synonyms |