We have comcash Point of Sales software which runs SQL Server. Everyday I come to work. Open EMS Sql Server Manager and export 3 columns from 2 different servers to mysql then upload results to PHPMyAdmin.
I am doing this for customers to search their points on the rewards card we offer to them.
I was wondering if there was an easier "DYNAMIC" way to set this up so that the PHP search can just pick what fields I need over the internet to the server, to send them back without me MANUALLY updating the results everyday. Just because its tedious and not accurate.
Thank you!
Regards,
Aaron