How to avoid Maximum execution error

[bootzwiz]

Hi,
I have a loop which inserts data to database .I need to insert 500 records one by one in a loop.

<?
for($i=0;$i<500;$i++){
---values insert into db
}
?>

After 30 -40 records inserting i am getting maximum execution error. Is there any alternative to handle this situation.

[b1randon]

Hi,
I have a loop which inserts data to database .I need to insert 500 records one by one in a loop.

<?
for($i=0;$i<500;$i++){
---values insert into db
}
?>

After 30 -40 records inserting i am getting maximum execution error. Is there any alternative to handle this situation.

Try using the Set_time_limit() function (http://www.php.net/set_time_limit ) which will reset the maximum execution timer to 0.

[b1randon]

Try using the Set_time_limit() function (http://www.php.net/set_time_limit ) which will reset the maximum execution timer to 0.

You should also consider you solution. Is there something more elegant than entering the records this way? It's horrible on performance.