query question ...

[nomad9]

Hi all!

i've got a field in my table name listID :

listID

1
2
3
5
4
7

listID contain just unique number so it's impossible to have 2 x 5

i need to do a query like this :

$sql = 'SELECT * FROM photoList WHERE listID = "'.$id.'"';

if $id = "5", is there a way to detect the value of listID before (in this example it's 3) and after (4) of the row selected ???

Thanx

[Sxooter]

select * from table where id<5 order by id desc limit 1;

reverse the < to a > for the number after 5, and do an order by id (without the desc) to get that number.

[nomad9]

thanx alot Sxooter