[SOLVED] before and after the row

[drisate]

Hey guys,

I need to retreive the order number of the row before and after a given id...

 

Table:

 

id | name | order

-----------------

1  |  patrick | 1

2  |  miguel | 2

3  |  michel | 3

 

let say i have id 2 as a reference. I need to retreive the order number 1 from patrick and 3 from michel

(1 row before, 1 row after)

 

Whats would be the SQL string for that?

[rhodesa]

Before

SELECT `order` FROM tableName WHERE `order` < (SELECT `order` FROM tableName WHERE id = 2) ORDER BY `order` DESC LIMIT 1

 

After

SELECT `order` FROM tableName WHERE `order` > (SELECT `order` FROM tableName WHERE id = 2) ORDER BY `order` ASC LIMIT 1

[drisate]

thx bro works great :-)