gdfhghjdfghgfhf Posted April 22, 2008 Share Posted April 22, 2008 Hello, i have a table in my database with a ID field... the ID is auto-incremented by 1 i already have a query which will display entry with (i.e.) id number 500 what i want to do is add a second query that will display the entry right after #500 i thought about just adding "WHERE id = id + 1" to the query, but some entries have been deleted, so the query could not work... how could i do this? Link to comment https://forums.phpfreaks.com/topic/102353-query-the-row-next-to/ Share on other sites More sharing options...
GingerRobot Posted April 22, 2008 Share Posted April 22, 2008 Try: SELECT * FROM tbl WHERE id > 500 ORDER BY id ASC LIMIT 1 Link to comment https://forums.phpfreaks.com/topic/102353-query-the-row-next-to/#findComment-524090 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.