I have the following php code:
sleep(65);
$query = "UPDATE database.table SET XXXXXXX = XXXXXXX - ".$YYYYYY." WHERE ZZZZZZZZ = '1111111111111111111'";
mysql_query($query);
The UPDATE is not working and I really need it after the 65 second sleep.
Any idea on how to do it? Your help will be highly appreciated.
Is PHP running under apache?
IIRC, typical PHP.ini files within server configurations will set a max_execution_time of some form. Maybe you're running into this limit?