jeff5656 Posted October 21, 2008 Share Posted October 21, 2008 I was using a script to export the database into excel. There are a lot of records and I got this error: Fatal error: Maximum execution time of 30 seconds exceeded in <b>E:\wamp\www\consults\export2c.php</b> on line <b>161</b><br /> How do I get around this? On a related note, what is the code to select only records between a certain date? Lets say the variable is procedure_date. $sql = "select * from $db_tblName, $DBtblName2 WHERE $db_tblName.procedure_date xxxx"; What do I put into xxxxx for a range between 10/1/2007 and 10/20/2008? Thanks. Link to comment https://forums.phpfreaks.com/topic/129452-a-time-out-fatal-error/ Share on other sites More sharing options...
genericnumber1 Posted October 21, 2008 Share Posted October 21, 2008 Increase the max_execution_time in your php.ini. Also, xxxx = BETWEEN '2007-10-01' AND '2007-10-20' Link to comment https://forums.phpfreaks.com/topic/129452-a-time-out-fatal-error/#findComment-671139 Share on other sites More sharing options...
thebadbad Posted October 21, 2008 Share Posted October 21, 2008 Or you can set the time limit for that script only, with set_time_limit(). Link to comment https://forums.phpfreaks.com/topic/129452-a-time-out-fatal-error/#findComment-671199 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.