Mysql - Query to get next & previous ID

[thestars]

How can I get the very next Primarykey and just previous Primarykey of a given row using mysql query?Please help me

[JonnoTheDev]

SELECT MAX(fieldname) AS lastPK, MAX(fieldname)+1 AS newPK FROM table

[thestars]

Hi,

 

In database, the IDs may be in random order and the difference between the two IDs may not be 1.

 

IDs will be like

 

1, 3, 4, 33, 10 etc.

 

So , I need 10 if current ID is 4.

Hope you got it.

[JonnoTheDev]

SELECT id FROM table ORDER BY id DESC LIMIT 2

 

This will give you the last 2 records

[thestars]

But this will give only the last two records.

[JonnoTheDev]

How can I get the very next Primarykey and just previous Primarykey of a given row using mysql query?

 

OK if you want the next and prev record from a given row just us > < opeartors

 

// next row

SELECT id FROM table WHERE id > 123 ORDER BY id ASC LIMIT 1

// prev row

SELECT id FROM table WHERE id < 123 ORDER BY id DESC LIMIT 1

[thestars]

Thank you so much Neil. Its working !!!! . I got the correct answer. Thanks