ansaurus

Question

query to ignore first 2 rows

Answer 1

+2 A:

USe limit LIMIT 2,98

Mchl 2010-08-02 10:40:45

you can't use limit with pager query

Paniyar 2010-08-02 11:07:27

That must be drupal specific limitation I think. Added a drupal tag.

Mchl 2010-08-02 11:45:15

Or perhaps you can use subqueries?

Mchl 2010-08-02 12:06:08

thank you for your edit and answer Mchl

Paniyar 2010-08-03 05:20:35

[`pager_query()`](http://api.drupal.org/api/function/pager_query/6) executes its own query, and doesn't accept any parameters that allow to refine it, or to expand it as requested by the OP.

kiamlaluno 2010-08-06 01:51:10

Answer 2

+1 A:

LIMIT 2,100

Add that to your SQL command, I think it should work.

ILMV 2010-08-02 10:41:06

As reported in other comments it's not possible to limit the query executed by `pager_query()`, as the function doesn't accept any parameter to refine the query it runs.

kiamlaluno 2010-08-06 01:45:38

Answer 3

+4 A:

If you are using Views, you can just set the offset to 2 which will ignore the first two records.

Kevin 2010-08-02 16:29:56

Answer 4

+2 A:

You can't use offsets with pager_query() which I assume you're using here. Maybe you need to reconsider how you're querying? Maybe run a query for the first two records, and then in your pager SQL use a WHERE condition to exclude the IDs of the first two results.

Dave Reid 2010-08-05 00:23:22

ansaurus

tags:

views:

answers:

query to ignore first 2 rows

related questions