[SOLVED] Skip a record
Posted: Fri Oct 01, 2004 9:46 am
Is it possible to skip the first found record from a table?
Cheers
Jim
Cheers
Jim
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
select * from someTable LIMIT 2, 30So you need to limit 1,30 in the example aboveThe LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments. The arguments must be integer constants. If two arguments are given, the first specifies the offset of the first row to return, the second specifies the maximum number of rows to return. The offset of the initial row is 0 (not 1):