self-updating database

[size=12pt]
I have a problem…

I am making a database and wanted to have an access to another online database, so if there is a new release of data in that database, it would automatically store to my database… what should i do?

pls. help. tnx much[/size]

You might check out cronjobs if you server supports it. http://www.cronjob.com/

Cronjob is a automated piece of code (can be a php script) that you set up to run daily, hourly of whatever. This however depend on your server provider. Not sure how the data is set in your database, but if your use a autoincrmental numeric ID and you take the ID from one database to the other your could simply check the MAX id in your database and get all the id that are higher then these from the other database.

can it support windows OS?

No not cronjobs, but on windows OS you could use windows Scheduled Tasks. Never use that on windows, but you should be able to schedule periodic task like this as well.

Sponsor our Newsletter | Privacy Policy | Terms of Service