Fatal Error on Recordset Add to Cart
I have this Quote page with items in the quote pulling from the database. A client can press the button that Adds All items to the cart in one shot. However, on one of the tables (there's 2 tables. One is the prduct and the other some optional products for the main product), the Optionals table to be exact, I can only iterate thru 1 item to place in cart. (see file below starting on line 326 (a while loop)). When I try to do more than one, the screen freezes on blank page and the error in the log says:
PHP Fatal error: Maximum execution time of 60 seconds exceeded in /home/jvdydf5kad9w/public_html/webassist/mysqli/rsobj.php on line 305
PHP Fatal error: Maximum execution time of 60 seconds exceeded in /home/jvdydf5kad9w/public_html/WA_eCart/WA_eCart_Definition_PHP.php on line 536
You can see the link below on button 'Order Complete Quote'.
The file is attached.
So if I change line 219 to 1 (selecting 1 record only), it works. If changed to 0 (to select all), it goes to blank page and executes forever. It only happens with that table.
$Recordset7 = new WA_MySQLi_RS("Recordset7",$convacc_cx,0);
$Recordset7->setQuery("SELECT * FROM cac_quote_new_optionals WHERE quotenum = '$quoteidponex' ORDER BY optional_id ASC");
I appreciate any help or suggestions you can provide.