Re: PHP & Postgres Displaying Results
| From: | Jeff MacDonald | Date: | Thu, 21 Sep 2000 21:08:17 +0000 |
| Subject: | Re: PHP & Postgres Displaying Results | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-3043@lists.php.net to get a copy of this message | ||
hi
use cursors for this..
jeff
On Thu, 21 Sep 2000, Broussard, Chris (CAP, VFS) wrote:
> I am trying to think of the best way to show results of a search, with
> results per page and previous/next button features, I am using PHP4.02, with
> PostgreSQL 7.02..
>
> Does anybody know if/how to get postgres to return rows w/ row id = x
> through y.. where the difference is the number of listings per page(a number
> range)... ???
>
> or if somebody has a better idea, or has done something similar to this
> before w/ postgres i am very interested..
>
> tia,
>
> Chris
>
>
>
Jeff MacDonald,
-----------------------------------------------------
PostgreSQL Inc | Hub.Org Networking Services
jeff@pgsql.com | jeff@hub.org
www.pgsql.com | www.hub.org
1-902-542-0713 | 1-902-542-3657
-----------------------------------------------------
Fascimile : 1 902 542 5386
IRC Nick : bignose