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? Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.