X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id A60E8D1C4CC for ; Tue, 12 Aug 2003 18:28:23 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 00698-03 for ; Tue, 12 Aug 2003 15:26:50 -0300 (ADT) Received: from www.postgresql.com (www.postgresql.com [64.117.225.209]) by svr1.postgresql.org (Postfix) with ESMTP id 127AAD1F52C for ; Tue, 12 Aug 2003 15:25:42 -0300 (ADT) Received: from lighthouse.MplusB.de (lighthouse.MplusB.de [193.102.49.10]) by www.postgresql.com (Postfix) with ESMTP id D68DDCF7AA8 for ; Tue, 12 Aug 2003 04:08:28 -0300 (ADT) Received: from [193.102.49.130] (helo=compass.MplusB.de) by lighthouse.MplusB.de with esmtp (Exim 3.35 #1 (Debian)) id 19mTDL-00073t-00; Tue, 12 Aug 2003 09:05:03 +0200 Received: from MplusB.de (gerd@sloop.MplusB.de [193.102.49.177]) by compass.MplusB.de (8.9.3p2/8.9.3/Debian 8.9.3-21) with ESMTP id JAA31693; Tue, 12 Aug 2003 09:05:03 +0200 X-Authentication-Warning: compass.MplusB.de: Host gerd@sloop.MplusB.de [193.102.49.177] claimed to be MplusB.de Message-ID: <3F38919E.109@MplusB.de> Date: Tue, 12 Aug 2003 09:05:02 +0200 From: Gerd Terlutter User-Agent: Mozilla/5.0 (X11; U; Linux i586; en-US; rv:1.0.2) Gecko/20030401 Debian/1.0.2-2 X-Accept-Language: de-de MIME-Version: 1.0 To: =?ISO-8859-1?Q?=C2ngelo_Marcos_Rigo?= Cc: Lynna Landstreet , pgsql-php@postgresql.org Subject: Re: Paging results References: <20030811181439.68382.qmail@web14805.mail.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable X-MIME-Autoconverted: from 8bit to quoted-printable by compass.MplusB.de id JAA31693 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/45 X-Sequence-Number: 2222 =C2ngelo Marcos Rigo wrote: > Do you have PEAR? >=20 > There is in > http://pear.php.net/package-info.php?package=3DDB_Pager, > the dbpager package, wich works very well >>Now, a new question: >> >>Does anyone know if there's a PHP class anywhere out >>there for paging >>results from a PostgreSQL query, similar to >>Paginator or ezResults which do >>that for MySQL? Or do I have to do the code for that >>from scratch? >> >>Alternatively, would it be difficult to adapt one of >>those to working with >>PostgreSQL instead of MySQL? >> >> >>Lynna Hi all, PEAR is general a good idea. I use PEAR::DB as wrapper for access do=20 different RDBMS, in my case PG and MySQL. nxet week i'll start with=20 transaction on MySQL3.23.51, but don't know what happends. Other=20 functionality is given during use PEAR::DB. This package supports 10 or=20 12 RDBMS. To convert MySQL to PG try this: http://ns2.ziet.zhitomir.ua/~fonin/projects/my2pg/my2pg_man.html Another good tipp is this: http://www.rot13.org/~dpavlin/sql.html If you have a good config-file for your source, you can switch by=20 changing only the param 'dbtype' e.g. psql or mysql. excuse my bad english, Gerd --=20 -------------------------------------------------------- # Gerd Terlutter | Mueller+Blanck Software GmbH # # gerd@MplusB.de | Gutenbergring 38 # # gerd.terlutter@web.de | D-22848 Noderstedt # # tel:0171/6992579 | tel:+49 40 500 171-1 # # Buero:040/500171-17 | fax:+49 40 500 171-71 # --------------------------------------------------------