mysql - get records from table starting from row 5 onwards -
i have mysql database , want records starting row 5 onwards. sing right
select * categories status = 1 limit 5 18446744073709551615 order sortorder asc
but throwing me error
error executing database query.
you have error in sql syntax; check manual corresponds mysql server version right syntax use near '18446744073709551615 order sortorder ' @ line 6
also not sure @ point if correct way of doing or not
thanks
you require offset
example:
select table limit $limit offset $offset; //or alternatively select table limit $offset,$limit;
regarding error:
remove number - in first place?
your statement should be:
select * categories status = 1 offset 5 order sortorder asc
Comments
Post a Comment