On Sat, 2006-02-04 at 23:24 -0500, vince@xxxxxxxxxxxxx wrote: > Quoting Jeff MacDonald <jam@xxxxxxxxxxxxxxxxxxxx>: > > ok.. now the hopefully easy question :): why are you trying to set > > things up this way? > Fair question. I'll tell you what I'm trying to do, and perhaps you > can advise a better solution. > > On my local machine I have a postpreSQL database. This database I update > constantly let's say. > > Hosted on another machine in cyberspace is my webserver. On this machine I have > a webpage that I want to update using data from the database on my local > machine. The webserver is running PHP/mySQL. > > I'm not sure if my web host would allow me to run a postgreSQL server on it as > well. So, ftp'ing the database up once a day say may not be an option. > ask. if they say no, get an isp that will say yes. > One of my original thoughts (before I understood the systems at all) > was that I would have to have a "cron" job running on my local machine > that would ftp up data as it was collected. The webserver, the next > time a php script ran, would check for new data, parse it, add it to > the mySQL database on the webserver, and then run the scripts using > the data from the webserver's mySQL server. > have you considered SOAP? as much as I "love" mySQL, it does work (most of the time ;)) and with SOAP you can still update your data fairly often. regards, J -- Jeff MacDonald Zoid Technologies, http://zoidtechnologies.com/
