Next Previous

[tobyhutton1234]

Hi There,

I trying to do a next/previous links.

The current page has a querystring("ID) example ID=15.

What I need to do is retive the previous entry ID this could be 14 or 7 or 2.
I am also trying to do this the next up ID so it could be 16 or 58 or 56989.

example code if the querystring is 15

<a href="?section=main&id=7><< Previous</a>
<a href="?section=main&id=45>Next >></a>

The ID number will change depending on the next or previous record ID.

Any thoughts

Thanks

[cemory]

The best option I can come up with would be two separate queries.

SELECT TOP 1 ID FROM [tblName] WHERE ID < 15 ORDER BY ID DESC;

SELECT TOP 1 ID FROM [tblName] WHERE ID > 15 ORDER BY ID;

[siteguru]

How do you know the next or previous ID number is not +1 or -1 from the current ID?

Remember that in a database all the records are effectively unsorted - like a bucket full of golf balls with numbers on them. They only become sorted in some way when you take them out (i.e. create a recordset) - and it is the act of taking them out that defines the sort method and order.

Perhaps if you describe your database table, give some example data, and explain what you're trying to achieve (i.e. how you know which record is going to be the next or previous one) then we might be able to help.

[ca4nul]

add next and previous values in global variable. and just call this variable

[Doug G]

Remember that in a database all the records are effectively unsorted - like a bucket full of golf balls with numbers on them. They only become sorted in some way when you take them out (i.e. create a recordset) - and it is the act of taking them out that defines the sort method and order.

That's a very nice description!

[siteguru]

I was going to say Bingo balls, but that might not have translated so well.