Next row

You have a table of names, you have retrieved a row with name $name, and you want the row for the next name in name order. MySQL LIMIT syntax makes this very easy:



SELECT *

FROM tbl

WHERE name > $name

ORDER BY name

LIMIT 1