Struggling to Paginate with PHP/MSSQL/PDO

[scottlpol2003]

I can output the pages with a list 1 | 2 | 3 | 4 pages but not the actual data.I'm using MSSQL, so I think the problem is having the LIMIT 10,20 clause in the query, but looking at the alternative ways to do this with MSSQL rather than MySQL look really complicated.If somebody could take a look at this script and let me know where I'm going wrong, that would be great.