Hi
I am having major problems getting this work
I need to pull 5 records from a table sorted by id but in desc order, the desc order would appear to be producing the problem
Here is what I mean
("select * from table order by id desc limit 6,5")
You would think that would produce record 7-11, but it produces record 5 -1, so using that you would think that
limit 12,5 would produce records 11-7, but it shows no records as I have only 11 records, so I tried
limit 10,5
but that shows row 1
I am totally confused, if I remove the desc I have no problems, but this is causing havoc.
Any help appreciated.
DC
I am having major problems getting this work
I need to pull 5 records from a table sorted by id but in desc order, the desc order would appear to be producing the problem
Here is what I mean
("select * from table order by id desc limit 6,5")
You would think that would produce record 7-11, but it produces record 5 -1, so using that you would think that
limit 12,5 would produce records 11-7, but it shows no records as I have only 11 records, so I tried
limit 10,5
but that shows row 1
I am totally confused, if I remove the desc I have no problems, but this is causing havoc.
Any help appreciated.
DC