Received: from nplex.globo.com (email.globo.com [200.208.9.53]) by postgresql.org (Postfix) with ESMTP id B125C475D10 for ; Thu, 1 Aug 2002 15:48:21 -0400 (EDT) Received: from [200.219.69.253] by nplex.globo.com with HTTP; Thu, 1 Aug 2002 16:48:03 -0300 Date: Thu, 1 Aug 2002 16:48:03 -0300 Message-ID: <3D3EEC5F000265C7@riosf05.globoi.com> In-Reply-To: <200208011209.19576.josh@agliodbs.com> From: angelo.rigo@globo.com Subject: Re: timezone To: josh@agliodbs.com Cc: pgsql-php@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-15" Content-Transfer-Encoding: quoted-printable X-Archive-Number: 200208/5 X-Sequence-Number: 1350 it displays 20 but have no link to next records how can i add it? '>'-- Mensagem Original -- '>'From: Josh Berkus '>'Reply-To: josh@agliodbs.com '>'To: angelo.rigo@globo.com '>'Subject: Re: [PHP] timezone '>'Date: Thu, 1 Aug 2002 12:09:19 -0700 '>'Cc: pgsql-php@postgresql.org '>' '>' '>'Angelo, '>' '>'> how can i display 20 results at a time and give a link to the next 20 or '>'> 50 or whatever records i do have on the database? '>' '>'Use LIMIT and OFFSET, which work the same in Postgres and MySQL: '>' '>'SELECT nome, to_char(data, 'DD.MM.YYYY') AS data '>' FROM aprovados '>' ORDER BY nome ASC '>' LIMIT 20 OFFSET 0; '>' '>'then '>' '>'SELECT nome, to_char(data, 'DD.MM.YYYY') AS data '>' FROM aprovados '>' ORDER BY nome ASC '>' LIMIT 20 OFFSET 20; '>' '>'etc. '>' '>'-- '>'-Josh Berkus '>' '>'______AGLIO DATABASE SOLUTIONS___________________________ '>' Josh Berkus '>' Complete information technology josh@agliodbs.com '>' and data management solutions (415) 565-7293 '>' for law firms, small businesses fax 621-2533 '>' and non-profit organizations. San Francisco '>' '>' '>'---------------------------(end of broadcast)--------------------------- '>'TIP 4: Don't 'kill -9' the postmaster ________________________________________ A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com= .br.