print ""; print ""; print "

"; print "

"; print "
 
 
DEMO   T o t a l   D a t a b a s e   R e p o r t

Click Here to return to the DEMO Starting Page

"; print "

 

Return to the Master Management Report

  Please note that this demo \"Cloaks\" personal contact information. Live systems display all information needed to manage the event (and reports are password protected)."; if ($do=="") { $do="total";} switch ($do) { case "total" : dototal ($regid,$cat,$meal,$affil,$years,$lastname,$firstname,$prefix,$badgename,$email,$$amountd,$paper,$post,$amountp,$checkamt,$namecheck,$checknum,$deposit,$poamt,$poname,$ponum,$sameinfo,$job,$level,$school,$sdistrict,$addr1,$addr2,$city,$state,$zip,$phone,$fax,$needs,$ihave,$presentation,$weddin,$thbr,$thlu,$thdin,$fribr,$bemail,$bprefix,$bfirstname,$blastname,$bschool,$baddr1,$baddr2,$bcity,$bstate,$bzip,$bsdistrict,$bphone,$bfax,$billreg,$comments,$confdate,$paid,$url); break; } // function dototal ($regid,$cat,$meal,$affil,$years,$lastname,$firstname,$prefix,$badgename,$email,$amountd,$paper,$post,$amountp,$checkamt,$namecheck,$checknum,$deposit,$poamt,$poname,$ponum,$sameinfo,$job,$level,$school,$sdistrict,$addr1,$addr2,$city,$state,$zip,$phone,$fax,$needs,$ihave,$presentation,$weddin,$thbr,$thlu,$thdin,$fribr,$bemail,$bprefix,$bfirstname,$blastname,$bschool,$baddr1,$baddr2,$bcity,$bstate,$bzip,$bsdistrict,$bphone,$bfax,$billreg,$comments,$confdate,$paid,$url){ global $date; global $postdate; $color[alt1]="#ffffff"; $color[alt2]="#6699cc"; $sql="SELECT * FROM event2003 where paid!='D' and paid!='d' order by regid"; $result = mysql_query($sql); print "\n"; print ""; print ""; print" "; print ""; print "\n"; for ($x=0; $x"; print ""; print ""; print ""; } print "
All Data (sorted by Tracking Number)

"; print "

CategoryE or P RegisteredTracking#PrefixFnameLnameEmailInvoiced (date) Group InvoiceAmount duePaper FormPostmarkPaid?Amount paid Confirmed dateCheck amountCheck nameCheck numberDeposit numberJob TitleOrganizationStreet AddressSecond AddressCityStateZipPhoneFaxBill emailBill First NameBill Last NameBill OrganizationBilling Street AddressBilling 2nd. AddressBill cityBill stateBill zipBill phoneBill fax Master Bill Reg Comments Mon Din Tues Lunch Tues W&C Wed Br Special Meal Special Needs Web Site Tables Elec Internet
$dcat$row[eregister]$row[regid] $row[prefix] $row[firstname] $row[lastname] Cloaked $row[regdate] $row[parent] $row[amountd] $row[paper] $row[post] $row[paid] $row[amountp] $row[confdate] $row[checkamt] $row[namecheck] $row[checknum] $row[deposit] $row[job] $row[school] Cloaked Cloaked Cloaked $row[state] Cloaked Cloaked $row[fax] Cloaked $row[bfirstname] $row[blastname] $row[bschool] Cloaked Cloaked Cloaked Cloaked Cloaked Cloaked $row[bfax] $row[billreg] $row[comments] $row[weddin] $row[thbr] $row[thlu] $row[thdin] $row[meal] $row[needs] $row[url] $row[etables] $row[electric] $row[internet]

"; } echo "

\n"; // print ""; ?>