hi all, i hope some of you can enlighten me. (sorry for my english)
this is the scenario, i have a infinite loop that is interrupted when set_time_limit reaches the limit, inside the loop performs a query to the DB.
when i run the php script in firefox, i can't access to the DB from another page of firefox (phpmyadmin, another script, etc) but i can access to the DB from Internet Explorer. I need to open the DB from the same browser without the DB crash.
i researched and came to the conclusion that there is not a problem of mysql DB.
Have any of you have idea how fix this?
I put a piece of code to give you an idea of how it works
<?php
set_time_limit(60);
while( true ){
..$sSql = "select state, value1, value... from table"
..$res = mysql_query($sSql,$conn);
..while ($row = mysql_fetch_assoc($res)){
....//do something with the result
..}
}
?>
