PHP & MySQL | Tutorials

David Carr

Select previous and next rows in MySQL

Selecting previous and next rows based on the current row is a common task in most web applications, Take this blog when viewing a post, their are the previous and next posts available at the bottom of each post.

MySQL makes this a simple process the following will get the previous row that has an id less then 2:

Using a sub query in the where clause you can use min and max to return the previous or next row:

//Previous row
SELECT id FROM table WHERE id = (select min(id) from table where id > '2'
​
//next row
SELECT id FROM table WHERE id = (select max(id) from table where id < '2'

 

Domains are often purchased from multiple providers, keeping track of where a domain is and its DNS settings can be tricky. Domain Mapper solves this by listing all your domains in one place. View your DNS settings and receive reminders to renew your domains. Try it today.

Support my work by donating with PayPal.

Subscribe to my newsletter

Subscribe and get my books and product announcements.

© 2009 - 2021 DC Blog. All code MIT license. All rights reserved.