CODEWITHSUNDEEP
phpms-access
elf1984
elf1984

Reputation: 299

Limiting query in MS Access in PHP

I`m rewriting an application that use MS Access as the database.

I was able to connect and fetch data from tables, but how can I apply limit and offset like SELECT * FROM tablename LIMIT 10 0?

Upvotes: 0

Views: 1099

Answers (3)

Raza Ahmed
Raza Ahmed

Reputation: 2751

http://phplens.com/lens/adodb/docs-adodb.htm#ex8 is much better solution. You can modify it a bit to suit your needs. By default it return in html table, which can be modified to get field names and specific number of rows as array

Upvotes: 0

Jayesh
Jayesh

Reputation: 1523

SELECT TOP 10 * FROM tablename

Similar thread(no offset allowed in access)

Upvotes: 3

Alex K.
Alex K.

Reputation: 175766

In Access the syntax is TOP n;

select top 10 * from tablename

Upvotes: 1

Related Questions