Unanswered: How to have Mysql Update Content Every 24 Hours
So I kind of have an issue. There is a FoxPro databse which I need to access information from. I tyhen need to take this information and put it on the web. Since I have no idea how to use FoxPro I was hoping I could have an automated script that would have MySQL import the FoxPRo(I think it uses MSSQL) database content and then have php read everything from Mysql. However the Foxpro database is ever changing and so we would ned to keep the Mysql update current, within 24 hours. So the question becomes, how could I import the FoxPro database into Mysql and how could I import/update the Mysql database every 24 hours (crontab?)?
if you think there is a better solution such as Just going directly from the FoxPro database that would be great. However I have been looking into it and it seems rather complicated to have php and FoxPro (MSSQL) interact but maybe I am under the wrong impression. I am open to any suggestions. Thanks!