$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
Last updated 22 May 2024
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 Last updated 22 May 2024 |
|