require_once(form.db.php');

    switch($_POST['gamechoice']){
        case 'BattleField 2':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, bf2Q1, bf2Q2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$bf2favkit', '$bf2favvehicle', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();
                break;
            case 'BattleField 2142':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, bf2142Q1, bf2142Q2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$bf2142favkit', '$bf2142favvehicle', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break;
            case 'Armed Assault':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, armAQ1, armAQ2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$armafavkit', '$armafavvehicle', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break;
            case 'UT 2004':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, ut2004Q1, ut2004Q2, ut2004Q3, ut2004Q4, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$ut2004gamename', '$ut2004favweapon', '$ut2004favvehicle', '$ut2004favmap', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break;
            case 'ET - Quake Wars':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, etQWarsQ1, etQWarsQ2, etQWarsQ3, etQWarsQ4, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$etQWarsFavClass', '$etQWarsFavWeapon', '$etQWarsFavVehicle', '$etQWarsFavDepoly', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break;                       
            case 'Counter Strike':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, csQ1, csQ2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$csfavkit', '$csfavmap', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break;
            case 'Counter Strike Source':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, cssQ1, cssQ2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$cssfavkit', '$cssfavmap', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break;             
            case 'Day Of Defeat':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, dodQ1, dodQ2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$dodfavkit', '$dodfavmap', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break;
            case 'Day Of Defeat Source':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, dodsQ1, dodsQ2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$dodsfavkit', '$dodsfavmap', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.phpl?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break;
            case 'Team Fortress 2':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, teamF2Q1, teamF2Q2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$tf2favclass', '$tf2favmap', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.phpl?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break;           
            case 'Guild Wars':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, gwQ1, gwQ2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$gwfavclass', '$gwtype', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();
               break;
            case 'World of Warcraft':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, wowQ1, wowQ2, wowQ3, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$wowclass', '$wowgpt', '$wowprof', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();
               break;
            case 'Second Life':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, slQ1, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$slgamename', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break;
            case 'Silent Hunter III':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, sHunter3Q1, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$shIIIgamename', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break; 
            case 'HellGate London':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, hGateLQ1, hGateLQ2, hGateLQ3, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$hGateLgamename', '$hGateLclass', '$hGateLweapon', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break;
            case 'Age Of Empires III':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, aoeIIIQ1, aoeIIIQ2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$aoeIIIgamename', '$aoeIIIFavCiv', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break;
            case 'Falcon 4.0 Allied Force':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, falcon4AFQ1, falcon4AFQ2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$falcon4AFgamename', '$falcon4AFFavJet', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break;
            case 'XBCONNECT':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, xbConnectQ1, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$xbconnectname', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break;
            case 'XBOX LIVE':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, xBoxLiveQ1, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$xboxlivename', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break;
            case 'OTHER':
                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, oGameQ1, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)
                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$othergame', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")

                    or die (mysql_error());

                if(!$sql){
                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");
                exit();

                }
                    print("<script> window.location.href =     \"thankyou.html\" </script>");
                        exit();             
               break;              
// This concludes the switch function, and the data should now be added to the database
            }