Php: getting next or previous row

1

Hey. I was wondering how you would best go about selecting the next or previous row with mysql. I dont know wether youd do it in php or in mysql.

Thanks.
_naaman