drisate Posted July 2, 2009 Share Posted July 2, 2009 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? Link to comment https://forums.phpfreaks.com/topic/164547-solved-before-and-after-the-row/ Share on other sites More sharing options...
rhodesa Posted July 2, 2009 Share Posted July 2, 2009 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 Link to comment https://forums.phpfreaks.com/topic/164547-solved-before-and-after-the-row/#findComment-867943 Share on other sites More sharing options...
drisate Posted July 2, 2009 Author Share Posted July 2, 2009 thx bro works great :-) Link to comment https://forums.phpfreaks.com/topic/164547-solved-before-and-after-the-row/#findComment-867958 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.