I'm looking to write something in PHP that modifies a MySQL variable every half hour on server time (for example).
I have a limited function set (phpinfo at http://www.mcjepp.com/info.php)
you are going to need to use a cron job to accomplish this
contact your webhost and see if they allow cron jobs to be run before you try and set one up
thanks for the quick response, i'll look into it.
how would this be done on a windows host machine?
Originally posted by Randuin how would this be done on a windows host machine?
you could write a batch file to call the php script from the command line and use windows task scheduler to run the task at any given time. i think with windows scheduler the most often you can run something is once a day, have a look at wincron (www.wincron.com) for unix crontab style functionality.
How do i execute a PHP script in windows? just run the file?
you first off need PHP to be installed with the CGI version for command line capabilities, not the apache module... to check that you can create a simple
<? phpinfo(); ?>
page and look at like the 4th option it'll tell you what it's installed with