开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜