Code: Select all
id item
---------
001 bike
004 book
003 spoon
002 tableHow do I retrieve the next id (id = 003)?
I use MySQL with PHP.
Thanks for your help
Moderator: General Moderators
Code: Select all
id item
---------
001 bike
004 book
003 spoon
002 tableCode: Select all
SELECT id
FROM table
WHERE id > '004'
ORDER BY id
LIMIT 1Code: Select all
$id = 4;
$query = "select * from myTable where id = ".($id - 1);Code: Select all
SELECT id
FROM table
WHERE ??? id="e;001"e; ???
ORDER BY itemCode: Select all
SELECT *
FROM table
WHERE item > 'bike'
ORDER BY item
LIMIT 1