Paging with MS Access

[guestabc]

I want to page my results, i have looked at the tutorial on this site though I have a problem if I try to addapt the code given in that tutorial for my website as I'm using MS Access instead of mySQL. The problem i have is with the LIMIT as it doesn't work with MS Access.

 

$sql = "SELECT * FROM Results WHERE sUser='$sTID' AND sWonLost='Won' OR sUser='$sTID' AND sWonLost='Placed' LIMIT $offset, $rowsperpage";

 

thanks

[sasa]

look http://answers.google.com/answers/threadview/id/437751.html