how do i select a row before a row?

[jianyuan]

how do i select a row before a row?

[Dean C]

SELECT fields FROM table WHERE uniqueid=((SELECT uniqueid FROM table WHERE uniqueid=x) - 1)

Untested but I can't see why it wouldn't work

[r937]

Mist, it wouldn't work before mysql 4.1 since it uses a subquery

plus, what if there's a gap in id numbers?

try this:

select id, foo, bar, qux
  from yourtable
 where id < $id
order 
    by id desc
limit 1

[Dean C]

Hehe good point ^^.

[jianyuan]

thank you very very much . you helped a LOT!