SQL SERVER 2 PHP WEB SEARCH

• olie480

  SSC-Addicted

  Points: 443

  More actions

  June 4, 2008 at 5:28 pm

  #187618

  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