OK...I have spent ALL DAY trying to figure a work-around for this one. I've been creating a message board for the company I work for using PHP and MS Access. I want to limit the number of posts per page to 10 (or whatever) and dynamically add a "page 1,2,3,4,ect." to the bottom of the page to navigate between the different pages.

freddydoesphp (the php GOD) has offered a lot of examples to do this using MySQL with a "SELECT bla bla bla LIMIT $offset,$limit" statement. The problem is that odbc (ie.MS ACCESS) doesn't recognize the LIMIT SQL function. I've spent all day trying to find a php work-around or odbc alternate to this problem with out any success. The best I found was a Forum Post which said odbc doesn't accept the LIMIT function, but gave no solution to the problem.

If anyone has any solutions to this problem, I would be eternaly in your debt.