Strange LIMIT problem?

[spikeZ]

Hi folks,
Just a quick question, why does this query...

$select = mysql_query("select * from vse_reservation LIMIT 30,40") or die(mysql_error()); 

return 40 rows? I always understood that the LIMIT command used as above should bring out lines 30 - 40.

Slightly puzzled?

SpikeZ

[r937]

spikez, when you say LIMIT M,N, M is the starting row number, and N is the number of rows

the first row is numbered 0

so LIMIT 20,10 returns rows 21-30

easy, eh?