"; //Get the table name to use echo "
"; //Get the student's last name $SQLstring = "SELECT DISTINCT L_Name FROM $table"; // echo "$SQLstring
"; $result = mysql_query($SQLstring); echo "
"; //Get the student's first name $SQLstring = "SELECT DISTINCT F_Name FROM $table WHERE L_Name='$lname'"; // echo "$SQLstring
"; $result = mysql_query($SQLstring); echo ""; //Get student's password echo " Student's password:
"; echo "

"; echo ""; if ($passwd == "") { // echo "No password"; } else { $SQLstring = "SELECT * FROM $table WHERE L_Name = '$lname' AND F_Name = '$fname'"; //check for master if ($passwd !== "QUAQUEEUCY") { $SQLstring = $SQLstring . " AND Password = '$passwd'"; } // echo $SQLstring . "
"; $result = mysql_query($SQLstring); while ($row = mysql_fetch_array($result)) { echo "
"; echo $row['L_Name'] . ", " . $row['F_Name'] . "
"; echo $row['ADDRESS'] . "
"; echo $row['CITY'] . ", " . $row['ST'] . " " . $row['ZIP'] . "
"; echo "Year: " . $row['GR'] . "
"; echo "

"; echo "The following is a non-audited recap of your account with the Washington High School Bands from " . $table . ", "; echo "updated " . $row['Todays_Date'] . ".
"; echo "

"; echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; //echo ""; //echo ""; //echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; echo "
Balance from previous year: " . $row['Previous_Bal'] . "
Deposits or Donations: " . $row['Donations'] . "
Pizza Ranch fundraisers: " . $row['Pizza_Ranch'] . "
Trip deposits: " . $row['Trip_Payment1_Deposits'] . "
HyVee Gift Cards: " . $row['Hy_Vee'] . "
Discount Cards: " . $row['Disc_Cards'] . "
Discount Card Donations: " . $row['Disc_Cards_Donation'] . "
Magazine Sales: " . $row['Magazine'] . "
Yonkers Coupon Sales: " . $row['Yonkers_Coupon'] . "
Poinsettia, bagtag, cheese, fruit sales and donations: " . $row['Pointsettia'] . "
Frozen Foods & Candle sales: " . $row['FrozenFood_Candle'] . "
Frozen Foods & Candle donations: " . $row['FrozenFood_Candle_Donation'] . "
Frozen Food Sales: " . $row['Froz_Food'] . "
Frozen Food donations: " . $row['Froz_Food_Donation'] . "
 
Total Deposits: " . $row['Sum'] . "
 
Withdraw for hotel: " . $row['Hotel'] . "
Trip payment 1 withdraw: " . $row['Trip_Payment1'] . "
Trip payment 2 withdraw: " .$row['Trip_Payment2'] . "
Trip payment 3 withdraw: " .$row['Trip_Payment3'] . "
Trip payment 4 withdraw: " .$row['Trip_Payment4'] . "
Trip Spending Money withdraw: " .$row['TripSpendingMoney'] . "
Misc. withdraws: " . $row['Withdrawls'] . "
Fundraising target amount: " . $row['Target_Amt'] . " (" . $row['Target_Met'] . ")
 
Total account balance:" . $row['Total_Acct_Bal'] . "
"; echo "

"; echo "Note that the previous year balance includes any amounts transferred from siblings. "; echo "The fundraising target amount is the target goal that all band members have to support "; echo "the program ($130 for marching band and $40 for non-marching band members)"; echo "

"; echo "If you have any questions regarding your account, please contact Dan Swets at "; echo "Daniel.Swets@augie.edu.
"; echo "

"; echo "Thank you,
"; echo "

"; echo "Jenifer K. Hawkinson, WHS Bands
"; } } ?>