title: Is it possible to create a php array with data from both mssql and mysql?
body: <p>Pretty much as per the title really - I've got a script which is, at the moment, pulling data from MySQL that was initially in MSSQL (another script pulls the information from the MSSQL databaseand populates a holding table in MySQL)</p>
  
  <p>This works fine up to a point, however I'm now getting to the stage where I could really be doing with pulling some information directly from the MSSQL database and some from the MySQL database.</p>
  
  <p>Is there any way of getting PHP to query both MySQL and MSSQL and return the information in a single array?</p>
  
  <p>e.g. if all my information about 10 shops sales for apples is held in MySQL and my information about oranges is held in MSSQL, can I run so that one array shows how many apples and oranges each shop has sold over the last month?</p>
  
  <p>Thanks</p>