Re: timezone

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(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco