Running PHP? on Foreign Website

[Adamba]

Hi all,

We have a site up and running which collects data from our technicians that are working 'on site' and was wondering whether i can run sql from my location to pull out/update the results.

I can log into the website my techies set up to browse the data but am trying to set up an active desktop setup with a 'web scrape' feel which just gives me a count of orders in the database so i know when there is something new to view.

I can do the sql which i guess would look something like:
"SELECT count(ordernos) as Count_Of_Orders FROM DB_Orders"

but am struggling with how to implement it into an html page.

any help would be much appreciated.

Many thanks.



Adam

 

[vbkris]

if the database is MySql then u can use the inbuilt mysql functions. or you may have to go in for ODBC...

Known is handfull, Unknown is worldfull

 

[lgarner]

The remote server must also allow access via MySQL (normally tcp port 3306) natively or via some tunnel.