I need some help trying to deal with some external xml files.
At the moment I load the contents of xml files via simplexml, create a temporary table in the database with mysql and output the contents in different ways. The temporary table is created so that different values can be calculated from the values given in the xml files (for comparisons etc). However this temporary table is created every time a user requests the page and the xml files take some time to load which is dependent on the external servers which less than ideal.
I modified the script so that instead of creating a temporary table, it creates a real table in the database, First it checks if the table exists, drops it, and creates a new one when the script is run. it all works perfectly for my requirements.
Now the problem comes when I want this to run every 5 minutes (as an example). I tried to set up a cron jon (I'm on shared hosting) but even through the time was set up right and the command line was set to path of the file from the errors I was getting that it doesn't actually run the php file, but it's more of a command of some sort...I'm no programmer and no nothing about these things.
How can I get my php file to run itself at a set interval?