Duffers
11-09-2007, 12:31 PM
I am struggling to work out how to do something or if it is even possible and hope someone can help.
I have a MYSQL database and use PHP to query it as well as display web pages.
I have a third party application which has fields I can copy and paste into an excel spreadsheet and using DDE links the excel cells automatically update when refreshed.
I would like to apply the same theory to MYSQL or PHP instead of Excel. When a web page is refreshed it queries the third party application and gives updated values, or maybe some way to update a MYSQL table with the data.
Is this possible?
I have looked up ODBC connectivity, OLE Links and DDE links. I can see that it is possible to have Excel or Access query MYSQL but not sure if MYSQL or PHP can query the third party app.
If someone can point me in the right direction of some tutorial or help in any other way I would appreciate it.
I have a MYSQL database and use PHP to query it as well as display web pages.
I have a third party application which has fields I can copy and paste into an excel spreadsheet and using DDE links the excel cells automatically update when refreshed.
I would like to apply the same theory to MYSQL or PHP instead of Excel. When a web page is refreshed it queries the third party application and gives updated values, or maybe some way to update a MYSQL table with the data.
Is this possible?
I have looked up ODBC connectivity, OLE Links and DDE links. I can see that it is possible to have Excel or Access query MYSQL but not sure if MYSQL or PHP can query the third party app.
If someone can point me in the right direction of some tutorial or help in any other way I would appreciate it.