Chris <matchett123@googlemail.com> writes:

> Can someone explain why the query below doesn't do as I hoped it would
> do...return the ten records proceeding the row with an id of 200744?
> Please note that id is not an auto increment and can jump from 200744
> to 200801.
>
> SELECT * FROM weeknumber WHERE id > 200744 ORDER BY id LIMIT 0,10
>
> Many thanks,
>
> Chris

Because you have ">" instead of "<"? proceeding means to go before.

Did you mean something more like

select * from loginattempts where id < 49 order by id desc limit 3;