[RESOLVED] Getting next and previous ID

[duny]

Need some help, need some one to help me on getting the next and previous id from a mysql query. THis is my code, I just don't know how to ge the previous id (Which are random) and the next id. They are 8 digit random numbers

$query = "select * from images WHERE drive = '$i[drive]' and id != '$id' ORDER by id"; // the ID is the current ID so i dont want to get that one.
$result = MySQL_query($query);
$i = MySQL_fetch_row($result);
$prev = $prev[id];
$next = $next[id];

The get link is as such http://thislink.com/index.php?viewer&id=58230450 which gets the id of the image.

[Piranha]

This will get the previous and next id in 2 different queries. Of course you need to make sure that no sql injection occurs, and validate that something is returned (that there are previous and returned id).

// Previous id
SELECT something
FROM somewhere
WHERE id < $id
ORDER BY id DESC
LIMIT 0, 1

// Next id
SELECT something
FROM somewhere
WHERE id > $id
ORDER BY id ASC
LIMIT 0, 1

[duny]

Thanks, got it.