Get the previous or next id

Hi all, I just built a news database for my site. I want to give the visitor ability to browse my news database. Problem is how to determine the next or previous news id for the current news she is reading, so I can give link(s), such as "<a href="news.php?id=$prev_id">PREVIOUS</a>" and/or "<a href="news.php?id=$next_id">NEXT</a>" if there is any. I'm using MYSQL for the database. Can anyone give me a suggestion? Thank you. Andy Wijaya www.mediahostnet.com ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie