Sql basic Query

imagine this table:

create table news (
id SERIAL,
newsdate date,
message text
);

Now i want to get a result table like this

id | next_id | prev_id | message
--------------------------------

So all the news should be ordered by their newsdate AND i want a
listing for each news which comes next.

I've started with something like

SELECT news1.id, news2.id, news3.id, message
FROM news AS news1, news AS news2, news AS news3
WHERE news1.id <> news2.id AND news2.id <> news3.id AND
news1.id <> news3.id;

but how do i get only those rows which show the ids which are next to
each other. I dont want to save an array index inside the table or
create a tree inside the table. i just want to get it sorted by date,
but not only vertical.

later i just want to ask with php like select * news_view where id =
5; and i can create a navigation easily just by calling myself with
another id.

i hope you understood my question

regards
janning

--
Planwerk 6 /websolutions
Herzogstraße 86
40215 Düsseldorf

fon 0211-6015919
fax 0211-6015917
http://www.planwerk6.de