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,开发者_如何学C but how can I apply limit and offset like SELECT * FROM tablename LIMIT 10 0
?
SELECT TOP 10 * FROM tablename
Similar thread(no offset allowed in access)
In Access the syntax is TOP n
;
select top 10 * from tablename
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
精彩评论