mysql - sorting and calling help

[CarCdr]

Originally Posted by Dean C

Yes Colin, I'm pretty sure what you said is right. LIMIT 0,6 would return the first 7 seven rows.

It is as I said...

The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments, which must be integer constants. With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the maximum number of rows to return.