it displays 20 but have no link to next records how can i add it? '>'-- Mensagem Original -- '>'From: Josh Berkus <josh@xxxxxxxxxxxx> '>'Reply-To: josh@xxxxxxxxxxxx '>'To: angelo.rigo@xxxxxxxxx '>'Subject: Re: [PHP] timezone '>'Date: Thu, 1 Aug 2002 12:09:19 -0700 '>'Cc: pgsql-php@xxxxxxxxxxxxxx '>' '>' '>'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@xxxxxxxxxxxx '>' 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.
