mysql limit clause

[Anon]

I have 44 records in a table. I want to be able to show 20 at a time. so if I have this query:

SELECT *
FROM table
WHERE id=x
order by field desc
limit 0,20

it returns the first 20 records.

however if I have this query:

SELECT *
FROM table
WHERE id=x
order by field desc
limit 20,40

it returns 24 records instead of 20.
WHAT UP WID DAT!?!?!?

[Anon]

The limit works like this...

limt x, y

where x is the record start number and y is the number of records from that point you want to show...So your last query should actually read:

SELECT *
FROM table
WHERE id=x
order by field desc
limit 20, 20

Hope this helps!!!

[ace21]

look at it. 0,20 start at 0 grab twenty rows
20,40 start at twenty grab 40 rows.

Ace21