Is there a way to put something into a query which ignores the first defined number of results.
For example, if I have the following query
SELECT * FROM mydata WHERE `name` = '".$name."' AND allowed = 'YES' ORDER BY `idnum` DESC LIMIT 20
Is there a way to ignore the first x number of results which are returned.
x is a number, so if your results brought back id numbers
and you said for it to ignore the first 4, then it would return
Can this be done?
Thanks in advance