Multiple data sources

Multiple data sources

mikedmasonmikedmason Posts: 36Questions: 11Answers: 0

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.

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 52,525Questions: 1Answers: 8,020 Site admin
    Answer ✓

    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

  • mikedmasonmikedmason Posts: 36Questions: 11Answers: 0

    Thanks!

This discussion has been closed.