\n");
print (" \n");
print (" NCACAA 2004 State Meeting: Individual Summary \n");
print (" \n");
require("../header.txt");
print (" \n");
print ("
Individual Summary
\n");
print ("
\n");
print (" \n");
print (" | | \n");
// print (" # in Party | \n");
print (" Member Name | \n");
print ("
\n");
$sql = "SELECT id, realname, total_amt, amt_paid, members, spouse, children, life_members
FROM registration
ORDER BY realname ";
$result = mysql_query ($sql) or die (mysql_error_message());
while( $row = mysql_fetch_array ($result))
{
// $party_cnt = ($row[members] + $row[spouse] + $row[children] + $row[life_members]);
// $party_total += $party_cnt ;
// $members_total += ($row[members] + $row[life_members]) ;
print (" \n");
print (" | View | \n");
// print (" $party_cnt | \n");
print (" $row[realname] | \n");
print ("
\n");
}
// print (" \n");
// print (" | | \n");
// print (" $party_total | \n");
// print (" $members_total | \n");
// print ("
\n");
print ("
\n");
print ("
\n");
print ("
\n");
print (" \n");
print (" | Name: | \n");
print (" $row[realname] | \n");
print ("
\n");
print (" \n");
print (" | Total Amt: | \n");
print (" \$$row[total_amt] | \n");
print ("
\n");
print (" \n");
print (" | Amt Paid To Date: | \n");
print (" \$$row[amt_paid] | \n");
print ("
\n");
print (" \n");
print (" | Amt Owed: | \n");
print (" \$" . $amt_owed . " | \n");
print ("
\n");
print (" \n");
print (" | E-Mail: | \n");
print (" $row[email] | \n");
print ("
\n");
if ($row[spouse_name] != '')
{
print (" \n");
print (" | Spouse Name: | \n");
print (" $row[spouse_name] | \n");
print ("
\n");
}
if ($row[child_name_age] != '')
{
print (" \n");
print (" | Children's Names/Ages: | \n");
print (" $row[child_name_age] | \n");
print ("
\n");
}
if ($row[special_guests] != '0')
{
print (" \n");
print (" | # Special Guests | \n");
print (" $row[special_guests] | \n");
print ("
\n");
}
if ($row[spouse] != '0')
{
print (" \n");
print (" | # Spouse | \n");
print (" $row[spouse] | \n");
print ("
\n");
}
if ($row[children] != '0')
{
print (" \n");
print (" | # Children | \n");
print (" $row[children] | \n");
print ("
\n");
}
if ($row[life_members] != '0')
{
print (" \n");
print (" | # Life Members | \n");
print (" $row[life_members] | \n");
print ("
\n");
}
if ($row[banquet_only] != '0')
{
print (" \n");
print (" | Banquet Only Tickets | \n");
print (" $row[banquet_only] | \n");
print ("
\n");
}
if ($row[golfers] != '0')
{
print (" \n");
print (" | # Golfers | \n");
print (" $row[golfers] | \n");
print ("
\n");
}
if ($row[meal1cnt] != '0')
{
print (" \n");
print (" | $meal1 | \n");
print (" $row[meal1cnt] | \n");
print ("
\n");
}
if ($row[meal2cnt] != '0')
{
print (" \n");
print (" | $meal2 | \n");
print (" $row[meal2cnt] | \n");
print ("
\n");
}
if ($row[meal3cnt] != '0')
{
print (" \n");
print (" | $meal3 | \n");
print (" $row[meal3cnt] | \n");
print ("
\n");
}
if ($row[meal4cnt] != '0')
{
print (" \n");
print (" | $meal4 | \n");
print (" $row[meal4cnt] | \n");
print ("
\n");
}
if ($row[meal5cnt] != '0')
{
print (" \n");
print (" | $meal5title | \n");
print (" $row[meal5cnt] | \n");
print ("
\n");
}
if ($row[meal6cnt] != '0')
{
print (" \n");
print (" | $meal6title | \n");
print (" $row[meal6cnt] | \n");
print ("
\n");
}
if ($row[special_tour1cnt] != '0')
{
print (" \n");
print (" | $special_tour1 | \n");
print (" $row[special_tour1cnt] | \n");
print ("
\n");
}
if ($row[event1cnt] != '0')
{
print (" \n");
print (" | $event1_title | \n");
print (" $row[event1cnt] | \n");
print ("
\n");
}
if ($row[event2cnt] != '0')
{
print (" \n");
print (" | $event2_title (Adult) | \n");
print (" $row[event2cnt] | \n");
print ("
\n");
}
if ($row[event3cnt] != '0')
{
print (" \n");
print (" | $event3_title | \n");
print (" $row[event3cnt] | \n");
print ("
\n");
}
if ($row[event4cnt] != '0')
{
print (" \n");
print (" | $event4 | \n");
print (" $row[event4cnt] | \n");
print ("
\n");
}
if ($row[event5cnt] != '0')
{
print (" \n");
print (" | $event5 | \n");
print (" $row[event5cnt] | \n");
print ("
\n");
}
if ($row[event6cnt] != '0')
{
print (" \n");
print (" | $event6 | \n");
print (" $row[event6cnt] | \n");
print ("
\n");
}
if ($row[event7cnt] != '0')
{
print (" \n");
print (" | $event7 | \n");
print (" $row[event7cnt] | \n");
print ("
\n");
}
if ($row[event8cnt] != '0')
{
print (" \n");
print (" | $event8 | \n");
print (" $row[event8cnt] | \n");
print ("
\n");
}
if ($row[event9cnt] != '0')
{
print (" \n");
print (" | $event9 | \n");
print (" $row[event9cnt] | \n");
print ("
\n");
}
if ($row[event10cnt] != '0')
{
print (" \n");
print (" | $event10 | \n");
print (" $row[event10cnt] | \n");
print ("
\n");
}
if ($row[event11cnt] != '0')
{
print (" \n");
print (" | $event11 | \n");
print (" $row[event11cnt] | \n");
print ("
\n");
}
if ($row[comments] != '')
{
print (" \n");
print (" | Comments: | \n");
print (" $row[comments] | \n");
print ("
\n");
}
print ("
\n");
print ("