griffinme

This might seem odd, because I managed to get it working. But, I don't understand why it is working when I didn't change how it works. I wanted to take some fairly generic DW generated code and turn it into a function to cut use repeatedly on other pages. It would not work and I kept fiddling with it and got nowhere. From all appearances it should work. It would work fine when just part of the page. Finally I stripped out all the extras that DW puts in until just the code needed was there and it worked. My question is why? // non-working function function updatebal($event3) { include('Connections/rentals.php'); mysql_select_db($database_rentals, $rentals); $query_bill3 = "SELECT cost FROM event_bill WHERE event_num = $event3"; $bill13 = mysql_query($query_bill3, $rentals) or die(mysql_error()); $row_bill3 = mysql_fetch_assoc($bill3); $totalRows_bill3 = mysql_num_rows($bill3); mysql_select_db($database_rentals, $rentals); $query_pay3 = "SELECT amount FROM payments WHERE eventId = $event3"; $pay3 = mysql_query($query_pay3, $rentals) or die(mysql_error()); $row_pay3 = mysql_fetch_assoc($pay3); $totalRows_pay3 = mysql_num_rows($pay3); mysql_select_db($database_rentals, $rentals); $query_eventbal3 = "SELECT * FROM events WHERE event_num = $event3"; $eventbal3 = mysql_query($query_eventbal3, $rentals) or die(mysql_error()); $row_eventbal3 = mysql_fetch_assoc($eventbal3); $totalRows_eventbal3 = mysql_num_rows($eventbal3); $totalbill3 = 0; do { $totalbill3 = ($row_bill3['cost'] + $totalbill3); } while ($row_bill3 = mysql_fetch_assoc($bill3)); $totalpay3 = 0; do { $totalpay3 = ($row_pay3['amount'] + $totalpay3); } while ($row_pay3 = mysql_fetch_assoc($pay3)); $totalbal3 = ($totalbill3 + $totalpay3); $updateSQL3 = sprintf("UPDATE events SET bal=$totalbal WHERE event_num = $event3"); mysql_select_db($database_rentals, $rentals); $Result3 = mysql_query($updateSQL3, $rentals) or die(mysql_error()); mysql_free_result($bill3); mysql_free_result($pay3); mysql_free_result($eventbal3); } // working function function updatebal($event3) { include('Connections/rentals.php'); mysql_select_db($database_rentals, $rentals); $query_pay3 = "SELECT amount FROM payments WHERE eventId = $event3"; $pay3 = mysql_query($query_pay3, $rentals); $query_bill3 = "SELECT cost FROM event_bill WHERE event_num = $event3"; $bill3 = mysql_query($query_bill3, $rentals); $totalpay3 = 0; while ($row_pay3 = mysql_fetch_assoc($pay3)) { $rowspay3 = $row_pay3['amount']; $totalpay3 += $rowspay3; } $totalbill3 = 0; while ($row_bill3 = mysql_fetch_assoc($bill3)) { $rowsbill3 = $row_bill3['cost']; $totalbill3 += $rowsbill3; } $totalbal3 = ($totalbill3 - $totalpay3); $updateSQL3 = sprintf("UPDATE events SET bal= $totalbal3 WHERE event_num = $event3"); mysql_select_db($database_rentals, $rentals); $Result3 = mysql_query($updateSQL3, $rentals) or die(mysql_error()); return($totalbal3); mysql_free_result($bill3); mysql_free_result($pay3); exit; }