Next/prev links

[Anon]

Hi guys,

I was wondering if you could help me out with a php/mysql problem. I have a table with records of "events". Each event has a date. I display the events in an HTML table and each of the titles is in itself a link to a new window where details of the event are displayed. My question is how to make next event/previous event links on the detail pages...

The events have of course id fields that are auto_increment and unique but the problem is the order of id's is not the same as the one of the dates and the events must be ordered by date. And, because you can also delete events, the ids are not consequent (some numbers are missing)...

I have read quite a lot of articles and tutorials but could not find what I needed. Could anyone point me to some useful information or do you have any tips howthis could be solved?

Many thanks in advance,
nmk_

[mikikg]

You can use mysql LIMIT function.

example:

mysql_query ("SELECT * FROM table WHERE field='mydata' ORDER BY date LIMIT $offset,$rec_per_page");

[Anon]

And how do i get the id of the next or prvious (by date) record?

Thanks,
nmk