Link to home
Start Free TrialLog in
Avatar of syedasimmeesaq
syedasimmeesaqFlag for United States of America

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

ASKER CERTIFIED SOLUTION
Avatar of Frank Tsao
Frank Tsao

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of syedasimmeesaq

ASKER

that didn't work..any other ideas there?
Avatar of Frank Tsao
Frank Tsao

Sorry, that batch file (and the scheduled task) would have to be created on the server, not on your local machine.
c:\php\php.exe -f c:\path\to\your\phpfile.php plus little bit more changes that works. Thanks