Multiple data sources

mikedmason

Hi Guys,
I uses the editor for a mysql database and I understand that process. I am hoping to pull in a mssql data using freetds (already set up and working) It doesn't need to utilize the editor functionality just read only. Whats the best way to do that? Do i create two folders one of editor and one of datatables and reference them separately in my PHP? I guess the question is what best practice to pull from two database types when Mysql is editor and MSSQL is just read only. Thanks for any tips.

allan

If you want to use read only data, I'd skip over the Editor PHP libraries and simply to a SELECT directly against the database to get the records you want. A lot more flexibility that way and you won't run into any of the limitations of the Editor libraries (for example they don't have a group by option).

Allan

mikedmason

Thanks!