doggee7

Thorpe, Turns out it was a timeout issue! A friend pointed me to set_time_limit(). When i set it to zero, though it took a full 59 seconds, my script finished without failing. Thanks for the swift response though!

Hello all, I have a looping structure that in super simplified format looks like this: for( "while theres results from mysql query" ) { for( "every day in the pst six months" ) { "Several other complex child loops, involving variable assignment, if-else and sql calls" } } The problem is, when i run this script with any more than three results from the original query, the whole page fails. After setting a counter within several of the loops, i've determined that the script dies at different iterations of the "for every day in the past six months" loop. I've checked the possibility of both timeout restrictions, and php memory limits, and i seem to be well within the boundaries of both. I am all out of ideas. Other than the possibilty of php getting lost in a sea of thousands of if's and then's i can't figure out how to solve this problem. If the script had errors, it should die at the same iteration everytime. Can anyone help me out??

Hello everyone, im new to the board and about 3 weeks new to php. I'm trying to create a script that gets distinct production names from a database, and then creates queries based on those production names, and inserts the query results into an array within a for loop. Heres what i have now: $prods = mysql_query("SELECT DISTINCT 'production' FROM 'logs' WHERE 'drv_id' = '".$drv_name); for($p = 0; $prod2 = mysql_fetch_assoc($prods); $p++) { $prod_arr[$p] = $prods2['production']; $prod_result[$p] = mysql_query("SELECT * FROM 'logs' WHERE 'production' = '".$prod_arr[$p]); } I'm trying to do this, so that i can reflect the results in another loop i have further on down the script, that would utilize the $prod_result[$p] contents to popullate fields in a table. Please let me know if there is a way to store multiple mysql_query results into a single array (maybe i need to be using nested arrays somehow?