php - Trouble in PDO and sqlsrv land -

I have established a site using PDO and MySQL databases on my local system. I use the PDO because when the site goes to the live server, I have to go to the user's SQL server and I had hoped that the PDO would take care of all my queries.

Now when I'm on a live server, the application uses the "LIMIT" function, then get an error. I realize that this is a MySQL specific task but PDO should not take care of conflict? How can I fix this so that the site works on MySQL and SQLSRV?

Thanks in advance.

Never develop into a technique that pruds to use a different technique is.

This fails because there is no SQL Server equivalent for LIMIT, so it can not be converted.

If you expect different backends, then the use of ANSI standard SQL is not of database specific things. If you expect to use only SQL Server in Prod, develop in SQL Server (a free version).