syedasimmeesaq
asked on
windows scheduler to run a php script
I have to run a php script on a windows server 2003 machine to update a field after every hour. the php script is
UPDATE MyTable SET LockField=0 WHERE LockField<time(CURTIME())- 3600;
how would I go about doing it.
Thanks
UPDATE MyTable SET LockField=0 WHERE LockField<time(CURTIME())-
how would I go about doing it.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry, that batch file (and the scheduled task) would have to be created on the server, not on your local machine.
ASKER
c:\php\php.exe -f c:\path\to\your\phpfile.ph p plus little bit more changes that works. Thanks
ASKER