2017 Annual Youth Sailing Dinner and Auction Fundraiser

May 13, 2017

Registrations Received

get_results($query);

if($result)
{
// while ($row = Mysql_fetch_array($result))
// while ($row = mysqli_fetch_array($result))
foreach($result as $key => $row) //Loops through the array $result
{
$previous_field = $field_number;
$field_number = $row->field_number;
if ($field_number < $previous_field) { echo "

“;
$ast=$ast+$adultsalmon;
$avt=$avt+$adultveg;
$yst=$yst+$youthsalmon;
$yvt=$yvt+$youthveg;
$fname=””;
$lname=””;
$adultsalmon=””;
$youthsalmon=””;
$pymt=””;
$adultveg=””;
$youthveg=””;
$attending=””;
$donation=””;
}
switch($field_number)

{
case 2.3:
$fname = $row->value;
break;
case 2.6:
$lname = $row->value;
break;
//Early Registration
case 4.3:
$adultsalmon = $row->value;
break;
case 9:
$pymt = $row->value;
break;
case 18:
$donation = “Yes”;
break;
case 19:
$attending = $row->value;
break;
case 20.3:
$adultveg = $row->value;
break;
case 22.3:
$youthsalmon = $row->value;
break;
case 23.3:
$youthveg = $row->value;
break;
//Late Registration
case 27.3:
$adultsalmon = $row->value;
break;
case 28.3:
$adultveg = $row->value;
break;
case 29.3:
$youthsalmon = $row->value;
break;
case 30.3:
$youthveg = $row->value;
break;
default:
break;
}
}
echo “

“;

$ast=$ast+$adultsalmon;
$avt=$avt+$adultveg;
$yst=$yst+$youthsalmon;
$yvt=$yvt+$youthveg;
$fname=””;
$lname=””;
$adultsalmon=””;
$youthsalmon=””;
$pymt=””;
$adultveg=””;
$youthveg=””;
$attending=””;
$donation=””;
}

$totaldinners = $ast+$avt+$yst+$yvt;

echo “

“;
?>

Adult Dinners
Youth Dinners
Name
Salmon
Vegetarian
Salmon
Vegetarian
Donation
Payment Type
” . $fname . ” ” . $lname . “ ” . $adultsalmon . “ ” . $adultveg . “ ” . $youthsalmon . “ ” . $youthveg . “ ” . $donation . “ ” . $pymt . “
” . $fname . ” ” . $lname . “ ” . $adultsalmon . “ ” . $adultveg . “ ” . $youthsalmon . “ ” . $youthveg . “ ” . $donation . “ ” . $pymt . “
Totals ” . $ast . “ ” . $avt . “ ” . $yst . “ ” . $yvt . “ Total Dinners: ” . $totaldinners . “ (Dinner Sold Out!)

If you would like to attend the auction, you are welcome to join us at 7:30 after dinner is finished.