Limit on query

[Anon]

I wrote

select * from my_table where (date>=$date1 and date<=$date2) limit 10,20

and it basically gave me from 10 till all the end of the query result

it didnt' display from 10 to 20

it display 10 till the end of the result 90

[Anon]

I foudn out the anser