using limit in access

[shawon22]

i'm trying to create a simple prev/next link using access database. but for some reason i can't use limit.

example:
$query = "SELECT * FROM table LIMIT 0, 10";

the above query doesn't work with access could somebody help me out plz
thank you

[swon]

LIMIT statement looks good, may you have other errors, like table name...

[mikeatrpi]

I thought LIMIT was mySQL-specific?

[DigitalExpl0it]

yes LIMIT will not work with Access nor with MsSQL..

you will need to use TOP

[DigitalExpl0it]

$sql = "SELECT TOP 5 * FROM News Order By NewsID ASC";