[Resolved] how select next database record

[Tomz]

Hi,

I have a page that displays contents of a database, one record per page.
On this page are 'next' and 'previous' links to diplay the next or previous record.

I don't want to select the record to display by putting the id of the database record in the WHERE in my SQL because there might be gaps in between these ID's.

How can I move one record back or forward and display that one?

[jayant]

u need some way to uniquely identify each record.
any kay other than ID that is unique to each record?

spaces should affect, but in anycase you can use the md5() hash of the ID and use MD5 of sql to compare like

WHERE MD5(id) = "{$_GET['id']}"

[Tomz]

Thanks for replying! I'm not sure that is going to solve my dilemma. Reading my post again I don't think that I was completely clear in what I meant.

There IS a unique key (id) for each record. This is the primairy key which is auto incremented for every record. Because there will be a lot of records added and deleted over time there will be gaps in this ID field. So it might looks something like 1,2,4,7,25,36,37,55...

So, for the 'next page' link I could not do something like

SELECT * FROM table WHERE id=$current_id+1

Isn't there something that can like move the record pointer (if there is such a thing) one step ahead or back, regardless of any ID or other info in the table, and then retrieve the data in that record?

[LordShryku]

You can find it.

SELECT min(id)
FROM table
WHERE id > 'your last id'

[Tomz]

Ofcourse... Thanks!