Lucky2710 Posted July 23, 2010 Share Posted July 23, 2010 There s an error somewhere in this code and i can't for the life of me find it. I've been trying to find it for the last couple of hours if you see a coding error please let me know. Thanks <?php include 'dbc.php'; page_protect(); ?> <?php //mySQL Connection Start mysql_connect ("localhost","user","pass"); mysql_select_db ("sports"); //mySQL Connection End //Get User id #'s $sql="SELECT id FROM users WHERE approved=1"; $result=mysql_query($sql); while($row = mysql_fetch_object($result)) { $ids[] = $row->id; } //Done Getting User id #'s //Call Game Results for Admin (Final Scores) function cfbPicks($ids) { $sql1 = "SELECT 'cfb_wk1_acc_Florida A&M at Miami (FL)', 'cfb_wk1_acc_Presbyterian at Wake Forest', 'cfb_wk1_acc_Samford at Florida State', 'cfb_wk1_acc_South Carolina State at Georgia Tech', 'cfb_wk1_acc_Weber State at Boston College', 'cfb_wk1_acc_North Texas at Clemson', 'cfb_wk1_acc_Western Carolina at North Carolina State', 'cfb_wk1_acc_Richmond at Virginia', 'cfb_wk1_acc_Elon at Duke', 'cfb_wk1_acc_LSU vs. North Carolina', 'cfb_wk1_acc_Navy vs. Maryland', 'cfb_wk1_acc_Boise State vs. Virginia Tech', 'cfb_wk2_acc_Duke at Wake Forest', 'cfb_wk2_acc_Georgia Tech at Kansas', 'cfb_wk2_acc_James Madison at Virginia Tech', 'cfb_wk2_acc_Kent State at Boston College', 'cfb_wk2_acc_Florida State at Oklahoma', 'cfb_wk2_acc_Presbyterian at Clemson', 'cfb_wk2_acc_Miami (FL) at Ohio State', 'cfb_wk2_acc_Morgan State at Maryland', 'cfb_wk2_acc_North Carolina State at UCF', 'cfb_wk2_acc_Virginia at USC', 'cfb_wk3_acc_Cincinnati at North Carolina State', 'cfb_wk3_acc_Georgia Tech at North Carolina', 'cfb_wk3_acc_Maryland at West Virginia', 'cfb_wk3_acc_East Carolina at Virginia Tech', 'cfb_wk3_acc_Brigham Young at Florida State', 'cfb_wk3_acc_Alabama at Duke', 'cfb_wk3_acc_Clemson at Auburn', 'cfb_wk3_acc_Wake Forest at Stanford', 'cfb_wk4_acc_Miami (FL) at Pittsburgh', 'cfb_wk4_acc_Wake Forest at Florida State', 'cfb_wk4_acc_North Carolina State at Georgia Tech', 'cfb_wk4_acc_Virginia Tech at Boston College', 'cfb_wk4_acc_FIU at Maryland', 'cfb_wk4_acc_Army at Duke', 'cfb_wk4_acc_North Carolina at Rutgers', 'cfb_wk4_acc_Virginia Military Institute at Virginia', 'cfb_wk5_acc_Notre Dame at Boston College', 'cfb_wk5_acc_Duke at Maryland', 'cfb_wk5_acc_Virginia Tech at North Carolina State', 'cfb_wk5_acc_East Carolina at North Carolina', 'cfb_wk5_acc_Georgia Tech at Wake Forest', 'cfb_wk5_acc_Miami (FL) at Clemson', 'cfb_wk5_acc_Florida State at Virginia', 'cfb_wk6_acc_Virginia at Georgia Tech', 'cfb_wk6_acc_Boston College at North Carolina State', 'cfb_wk6_acc_Clemson at North Carolina', 'cfb_wk6_acc_Navy at Wake Forest', 'cfb_wk6_acc_Florida State at Miami (FL)', 'cfb_wk6_acc_Central Michigan at Virginia Tech', 'cfb_wk7_acc_Boston College at Florida State', 'cfb_wk7_acc_Middle Tennessee at Georgia Tech', 'cfb_wk7_acc_Miami (FL) at Duke', 'cfb_wk7_acc_North Carolina State at East Carolina', 'cfb_wk7_acc_Maryland at Clemson', 'cfb_wk7_acc_North Carolina at Virginia', 'cfb_wk7_acc_Wake Forest at Virginia Tech', 'cfb_wk8_acc_Maryland at Boston College', 'cfb_wk8_acc_Georgia Tech at Clemson', 'cfb_wk8_acc_Eastern Michigan at Virginia', 'cfb_wk8_acc_Duke at Virginia Tech', 'cfb_wk8_acc_North Carolina at Miami (FL)', 'cfb_wk9_acc_Florida State at North Carolina State', 'cfb_wk9_acc_Clemson at Boston College', 'cfb_wk9_acc_Wake Forest at Maryland', 'cfb_wk9_acc_William & Mary at North Carolina', 'cfb_wk9_acc_Miami (FL) at Virginia', 'cfb_wk9_acc_Duke at Navy', 'cfb_wk10_acc_Georgia Tech at Virginia Tech', 'cfb_wk10_acc_North Carolina at Florida State', 'cfb_wk10_acc_Virginia at Duke', 'cfb_wk10_acc_Boston College at Wake Forest', 'cfb_wk10_acc_North Carolina State at Clemson', 'cfb_wk10_acc_Maryland at Miami (FL)', 'cfb_wk11_acc_Clemson at Florida State', 'cfb_wk11_acc_Miami (FL) at Georgia Tech', 'cfb_wk11_acc_Boston College at Duke', 'cfb_wk11_acc_Wake Forest at North Carolina State', 'cfb_wk11_acc_Virginia Tech at North Carolina', 'cfb_wk11_acc_Maryland at Virginia', 'cfb_wk12_acc_Duke at Georgia Tech', 'cfb_wk12_acc_Virginia at Boston College', 'cfb_wk12_acc_Florida State at Maryland', 'cfb_wk12_acc_North Carolina State at North Carolina', 'cfb_wk12_acc_Clemson at Wake Forest', 'cfb_wk12_acc_Virginia Tech at Miami (FL)', 'cfb_wk13_acc_Florida at Florida State', 'cfb_wk13_acc_Georgia Tech at Georgia', 'cfb_wk13_acc_North Carolina State at Maryland', 'cfb_wk13_acc_North Carolina at Duke', 'cfb_wk13_acc_Boston College at Syracuse', 'cfb_wk13_acc_South Carolina at Clemson', 'cfb_wk13_acc_Wake Forest at Vanderbilt', 'cfb_wk13_acc_Virginia at Virginia Tech', 'cfb_wk13_acc_South Florida at Miami (FL)', 'cfb_wk1_sec_Southern Miss at South Carolina', 'cfb_wk1_sec_Arkansas State at Auburn', 'cfb_wk1_sec_Tennessee Tech at Arkansas', 'cfb_wk1_sec_Miami (OH) at Florida', 'cfb_wk1_sec_Louisiana-Lafayette at Georgia', 'cfb_wk1_sec_Jacksonville State at Mississippi', 'cfb_wk1_sec_Northwestern at Vanderbilt', 'cfb_wk1_sec_San Jose State at Alabama', 'cfb_wk1_sec_Memphis at Mississippi State', 'cfb_wk1_sec_Tennessee-Martin at Tennessee', 'cfb_wk1_sec_Kentucky at Louisville', 'cfb_wk1_sec_LSU vs. North Carolina', 'cfb_wk2_sec_Auburn at Mississippi State', 'cfb_wk2_sec_South Florida at Florida', 'cfb_wk2_sec_Western Kentucky at Kentucky', 'cfb_wk2_sec_LSU at Vanderbilt', 'cfb_wk2_sec_Arkansas vs. Louisiana-Monroe', 'cfb_wk2_sec_Georgia at South Carolina', 'cfb_wk2_sec_Penn State at Alabama', 'cfb_wk2_sec_Oregon at Tennessee', 'cfb_wk2_sec_Mississippi at Tulane', 'cfb_wk3_sec_Arkansas at Georgia', 'cfb_wk3_sec_Akron at Kentucky', 'cfb_wk3_sec_Vanderbilt at Mississippi', 'cfb_wk3_sec_Furman at South Carolina', 'cfb_wk3_sec_Alabama at Duke', 'cfb_wk3_sec_Florida at Tennessee', 'cfb_wk3_sec_Clemson at Auburn', 'cfb_wk3_sec_Mississippi State at LSU', 'cfb_wk4_sec_South Carolina at Auburn', 'cfb_wk4_sec_Alabama at Arkansas', 'cfb_wk4_sec_Kentucky at Florida', 'cfb_wk4_sec_Fresno State at Mississippi', 'cfb_wk4_sec_Georgia at Mississippi State', 'cfb_wk4_sec_UAB at Tennessee', 'cfb_wk4_sec_West Virginia at LSU', 'cfb_wk5_sec_Louisiana-Monroe at Auburn', 'cfb_wk5_sec_Vanderbilt at Connecticut', 'cfb_wk5_sec_Kentucky at Mississippi', 'cfb_wk5_sec_Florida at Alabama', 'cfb_wk5_sec_Alcorn State at Mississippi State', 'cfb_wk5_sec_Georgia at Colorado', 'cfb_wk5_sec_Tennessee at LSU', 'cfb_wk6_sec_LSU at Florida', 'cfb_wk6_sec_Tennessee at Georgia', 'cfb_wk6_sec_Auburn at Kentucky', 'cfb_wk6_sec_Eastern Michigan at Vanderbilt', 'cfb_wk6_sec_Arkansas vs. Texas A&M', 'cfb_wk6_sec_Alabama at South Carolina', 'cfb_wk6_sec_Mississippi State at Houston', 'cfb_wk7_sec_Arkansas at Auburn', 'cfb_wk7_sec_Mississippi State at Florida', 'cfb_wk7_sec_Vanderbilt at Georgia', 'cfb_wk7_sec_South Carolina at Kentucky', 'cfb_wk7_sec_Mississippi at Alabama', 'cfb_wk7_sec_McNeese State at LSU', 'cfb_wk8_sec_LSU at Auburn', 'cfb_wk8_sec_Mississippi at Arkansas', 'cfb_wk8_sec_Georgia at Kentucky', 'cfb_wk8_sec_South Carolina at Vanderbilt', 'cfb_wk8_sec_UAB at Mississippi State', 'cfb_wk8_sec_Alabama at Tennessee', 'cfb_wk9_sec_Vanderbilt at Arkansas', 'cfb_wk9_sec_Auburn at Mississippi', 'cfb_wk9_sec_Kentucky at Mississippi State', 'cfb_wk9_sec_Tennessee at South Carolina', 'cfb_wk9_sec_Florida vs. Georgia', 'cfb_wk10_sec_Chattanooga at Auburn', 'cfb_wk10_sec_Idaho State at Georgia', 'cfb_wk10_sec_Charleston Southern at Kentucky', 'cfb_wk10_sec_Louisiana-Lafayette at Mississippi', 'cfb_wk10_sec_Florida at Vanderbilt', 'cfb_wk10_sec_Arkansas at South Carolina', 'cfb_wk10_sec_Alabama at LSU', 'cfb_wk10_sec_Tennessee at Memphis', 'cfb_wk11_sec_Georgia at Auburn', 'cfb_wk11_sec_UTEP at Arkansas', 'cfb_wk11_sec_South Carolina at Florida', 'cfb_wk11_sec_Vanderbilt at Kentucky', 'cfb_wk11_sec_Mississippi State at Alabama', 'cfb_wk11_sec_Mississippi at Tennessee', 'cfb_wk11_sec_Louisiana-Monroe at LSU', 'cfb_wk12_sec_Appalachian State at Florida', 'cfb_wk12_sec_Tennessee at Vanderbilt', 'cfb_wk12_sec_Arkansas at Mississippi State', 'cfb_wk12_sec_Troy at South Carolina', 'cfb_wk12_sec_Georgia State at Alabama', 'cfb_wk12_sec_Mississippi at LSU', 'cfb_wk13_sec_Auburn at Alabama', 'cfb_wk13_sec_LSU at Arkansas', 'cfb_wk13_sec_Florida at Florida State', 'cfb_wk13_sec_Georgia Tech at Georgia', 'cfb_wk13_sec_South Carolina at Clemson', 'cfb_wk13_sec_Wake Forest at Vanderbilt', 'cfb_wk13_sec_Kentucky at Tennessee', 'cfb_wk13_sec_Mississippi State at Mississippi' FROM users WHERE id = '54'"; $result1 = mysql_query($sql1); while ($g = mysql_fetch_object($result1)) { $games_g_acc = array( array($g->'cfb_wk1_acc_Florida A&M at Miami (FL)',$g->'cfb_wk1_acc_Presbyterian at Wake Forest',$g->'cfb_wk1_acc_Samford at Florida State',$g->'cfb_wk1_acc_South Carolina State at Georgia Tech',$g->'cfb_wk1_acc_Weber State at Boston College',$g->'cfb_wk1_acc_North Texas at Clemson',$g->'cfb_wk1_acc_Western Carolina at North Carolina State',$g->'cfb_wk1_acc_Richmond at Virginia',$g->'cfb_wk1_acc_Elon at Duke',$g->'cfb_wk1_acc_LSU vs. North Carolina',$g->'cfb_wk1_acc_Navy vs. Maryland',$g->'cfb_wk1_acc_Boise State vs. Virginia Tech'), array($g->'cfb_wk2_acc_Duke at Wake Forest',$g->'cfb_wk2_acc_Georgia Tech at Kansas',$g->'cfb_wk2_acc_James Madison at Virginia Tech',$g->'cfb_wk2_acc_Kent State at Boston College',$g->'cfb_wk2_acc_Florida State at Oklahoma',$g->'cfb_wk2_acc_Presbyterian at Clemson',$g->'cfb_wk2_acc_Miami (FL) at Ohio State',$g->'cfb_wk2_acc_Morgan State at Maryland',$g->'cfb_wk2_acc_North Carolina State at UCF',$g->'cfb_wk2_acc_Virginia at USC'), array($g->'cfb_wk3_acc_Cincinnati at North Carolina State',$g->'cfb_wk3_acc_Georgia Tech at North Carolina',$g->'cfb_wk3_acc_Maryland at West Virginia',$g->'cfb_wk3_acc_East Carolina at Virginia Tech',$g->'cfb_wk3_acc_Brigham Young at Florida State',$g->'cfb_wk3_acc_Alabama at Duke',$g->'cfb_wk3_acc_Clemson at Auburn',$g->'cfb_wk3_acc_Wake Forest at Stanford'), array($g->'cfb_wk4_acc_Miami (FL) at Pittsburgh',$g->'cfb_wk4_acc_Wake Forest at Florida State',$g->'cfb_wk4_acc_North Carolina State at Georgia Tech',$g->'cfb_wk4_acc_Virginia Tech at Boston College',$g->'cfb_wk4_acc_FIU at Maryland',$g->'cfb_wk4_acc_Army at Duke',$g->'cfb_wk4_acc_North Carolina at Rutgers',$g->'cfb_wk4_acc_Virginia Military Institute at Virginia'), array($g->'cfb_wk5_acc_Notre Dame at Boston College',$g->'cfb_wk5_acc_Duke at Maryland',$g->'cfb_wk5_acc_Virginia Tech at North Carolina State',$g->'cfb_wk5_acc_East Carolina at North Carolina',$g->'cfb_wk5_acc_Georgia Tech at Wake Forest',$g->'cfb_wk5_acc_Miami (FL) at Clemson',$g->'cfb_wk5_acc_Florida State at Virginia'), array($g->'cfb_wk6_acc_Virginia at Georgia Tech',$g->'cfb_wk6_acc_Boston College at North Carolina State',$g->'cfb_wk6_acc_Clemson at North Carolina',$g->'cfb_wk6_acc_Navy at Wake Forest',$g->'cfb_wk6_acc_Florida State at Miami (FL)',$g->'cfb_wk6_acc_Central Michigan at Virginia Tech'), array($g->'cfb_wk7_acc_Boston College at Florida State',$g->'cfb_wk7_acc_Middle Tennessee at Georgia Tech',$g->'cfb_wk7_acc_Miami (FL) at Duke',$g->'cfb_wk7_acc_North Carolina State at East Carolina',$g->'cfb_wk7_acc_Maryland at Clemson',$g->'cfb_wk7_acc_North Carolina at Virginia',$g->'cfb_wk7_acc_Wake Forest at Virginia Tech'), array($g->'cfb_wk8_acc_Maryland at Boston College',$g->'cfb_wk8_acc_Georgia Tech at Clemson',$g->'cfb_wk8_acc_Eastern Michigan at Virginia',$g->'cfb_wk8_acc_Duke at Virginia Tech',$g->'cfb_wk8_acc_North Carolina at Miami (FL)'), array($g->'cfb_wk9_acc_Florida State at North Carolina State',$g->'cfb_wk9_acc_Clemson at Boston College',$g->'cfb_wk9_acc_Wake Forest at Maryland',$g->'cfb_wk9_acc_William & Mary at North Carolina',$g->'cfb_wk9_acc_Miami (FL) at Virginia',$g->'cfb_wk9_acc_Duke at Navy'), array($g->'cfb_wk10_acc_Georgia Tech at Virginia Tech',$g->'cfb_wk10_acc_North Carolina at Florida State',$g->'cfb_wk10_acc_Virginia at Duke',$g->'cfb_wk10_acc_Boston College at Wake Forest',$g->'cfb_wk10_acc_North Carolina State at Clemson',$g->'cfb_wk10_acc_Maryland at Miami (FL)'), array($g->'cfb_wk11_acc_Clemson at Florida State',$g->'cfb_wk11_acc_Miami (FL) at Georgia Tech',$g->'cfb_wk11_acc_Boston College at Duke',$g->'cfb_wk11_acc_Wake Forest at North Carolina State',$g->'cfb_wk11_acc_Virginia Tech at North Carolina',$g->'cfb_wk11_acc_Maryland at Virginia'), array($g->'cfb_wk12_acc_Duke at Georgia Tech',$g->'cfb_wk12_acc_Virginia at Boston College',$g->'cfb_wk12_acc_Florida State at Maryland',$g->'cfb_wk12_acc_North Carolina State at North Carolina',$g->'cfb_wk12_acc_Clemson at Wake Forest',$g->'cfb_wk12_acc_Virginia Tech at Miami (FL)'), array($g->'cfb_wk13_acc_Florida at Florida State',$g->'cfb_wk13_acc_Georgia Tech at Georgia',$g->'cfb_wk13_acc_North Carolina State at Maryland',$g->'cfb_wk13_acc_North Carolina at Duke',$g->'cfb_wk13_acc_Boston College at Syracuse',$g->'cfb_wk13_acc_South Carolina at Clemson',$g->'cfb_wk13_acc_Wake Forest at Vanderbilt',$g->'cfb_wk13_acc_Virginia at Virginia Tech',$g->'cfb_wk13_acc_South Florida at Miami (FL)') ); } while ($g = mysql_fetch_object($result1)) { $games_g_sec = array( array($g->'cfb_wk1_sec_Southern Miss at South Carolina',$g->'cfb_wk1_sec_Arkansas State at Auburn',$g->'cfb_wk1_sec_Tennessee Tech at Arkansas',$g->'cfb_wk1_sec_Miami (OH) at Florida',$g->'cfb_wk1_sec_Louisiana-Lafayette at Georgia',$g->'cfb_wk1_sec_Jacksonville State at Mississippi',$g->'cfb_wk1_sec_Northwestern at Vanderbilt',$g->'cfb_wk1_sec_San Jose State at Alabama',$g->'cfb_wk1_sec_Memphis at Mississippi State',$g->'cfb_wk1_sec_Tennessee-Martin at Tennessee',$g->'cfb_wk1_sec_Kentucky at Louisville',$g->'cfb_wk1_sec_LSU vs. North Carolina'), array($g->'cfb_wk2_sec_Auburn at Mississippi State',$g->'cfb_wk2_sec_South Florida at Florida',$g->'cfb_wk2_sec_Western Kentucky at Kentucky',$g->'cfb_wk2_sec_LSU at Vanderbilt',$g->'cfb_wk2_sec_Arkansas vs. Louisiana-Monroe',$g->'cfb_wk2_sec_Georgia at South Carolina',$g->'cfb_wk2_sec_Penn State at Alabama',$g->'cfb_wk2_sec_Oregon at Tennessee',$g->'cfb_wk2_sec_Mississippi at Tulane'), array($g->'cfb_wk3_sec_Arkansas at Georgia',$g->'cfb_wk3_sec_Akron at Kentucky',$g->'cfb_wk3_sec_Vanderbilt at Mississippi',$g->'cfb_wk3_sec_Furman at South Carolina',$g->'cfb_wk3_sec_Alabama at Duke',$g->'cfb_wk3_sec_Florida at Tennessee',$g->'cfb_wk3_sec_Clemson at Auburn',$g->'cfb_wk3_sec_Mississippi State at LSU'), array($g->'cfb_wk4_sec_South Carolina at Auburn',$g->'cfb_wk4_sec_Alabama at Arkansas',$g->'cfb_wk4_sec_Kentucky at Florida',$g->'cfb_wk4_sec_Fresno State at Mississippi',$g->'cfb_wk4_sec_Georgia at Mississippi State',$g->'cfb_wk4_sec_UAB at Tennessee',$g->'cfb_wk4_sec_West Virginia at LSU'), array($g->'cfb_wk5_sec_Louisiana-Monroe at Auburn',$g->'cfb_wk5_sec_Vanderbilt at Connecticut',$g->'cfb_wk5_sec_Kentucky at Mississippi',$g->'cfb_wk5_sec_Florida at Alabama',$g->'cfb_wk5_sec_Alcorn State at Mississippi State',$g->'cfb_wk5_sec_Georgia at Colorado',$g->'fb_wk5_sec_Tennessee at LSU'), array($g->'cfb_wk6_sec_LSU at Florida',$g->'cfb_wk6_sec_Tennessee at Georgia',$g->'cfb_wk6_sec_Auburn at Kentucky',$g->'cfb_wk6_sec_Eastern Michigan at Vanderbilt',$g->'cfb_wk6_sec_Arkansas vs. Texas A&M',$g->'cfb_wk6_sec_Alabama at South Carolina',$g->'cfb_wk6_sec_Mississippi State at Houston'), array($g->'cfb_wk7_sec_Arkansas at Auburn',$g->'cfb_wk7_sec_Mississippi State at Florida',$g->'cfb_wk7_sec_Vanderbilt at Georgia',$g->'cfb_wk7_sec_South Carolina at Kentucky',$g->'cfb_wk7_sec_Mississippi at Alabama',$g->'cfb_wk7_sec_McNeese State at LSU'), array($g->'cfb_wk8_sec_LSU at Auburn',$g->'cfb_wk8_sec_Mississippi at Arkansas',$g->'cfb_wk8_sec_Georgia at Kentucky',$g->'cfb_wk8_sec_South Carolina at Vanderbilt',$g->'cfb_wk8_sec_UAB at Mississippi State',$g->'cfb_wk8_sec_Alabama at Tennessee'), array($g->'cfb_wk9_sec_Vanderbilt at Arkansas',$g->'cfb_wk9_sec_Auburn at Mississippi',$g->'cfb_wk9_sec_Kentucky at Mississippi State',$g->'cfb_wk9_sec_Tennessee at South Carolina',$g->'cfb_wk9_sec_Florida vs. Georgia'), array($g->'cfb_wk10_sec_Chattanooga at Auburn',$g->'cfb_wk10_sec_Idaho State at Georgia',$g->'cfb_wk10_sec_Charleston Southern at Kentucky',$g->'cfb_wk10_sec_Louisiana-Lafayette at Mississippi',$g->'cfb_wk10_sec_Florida at Vanderbilt',$g->'cfb_wk10_sec_Arkansas at South Carolina',$g->'cfb_wk10_sec_Alabama at LSU',$g->'cfb_wk10_sec_Tennessee at Memphis'), array($g->'cfb_wk11_sec_Georgia at Auburn',$g->'cfb_wk11_sec_UTEP at Arkansas',$g->'cfb_wk11_sec_South Carolina at Florida',$g->'cfb_wk11_sec_Vanderbilt at Kentucky',$g->'cfb_wk11_sec_Mississippi State at Alabama',$g->'cfb_wk11_sec_Mississippi at Tennessee',$g->'cfb_wk11_sec_Louisiana-Monroe at LSU'), array($g->'cfb_wk12_sec_Appalachian State at Florida',$g->'cfb_wk12_sec_Tennessee at Vanderbilt',$g->'cfb_wk12_sec_Arkansas at Mississippi State',$g->'cfb_wk12_sec_Troy at South Carolina',$g->'cfb_wk12_sec_Georgia State at Alabama',$g->'cfb_wk12_sec_Mississippi at LSU'), array($g->'cfb_wk13_sec_Auburn at Alabama',$g->'cfb_wk13_sec_LSU at Arkansas',$g->'cfb_wk13_sec_Florida at Florida State',$g->'cfb_wk13_sec_Georgia Tech at Georgia',$g->'cfb_wk13_sec_South Carolina at Clemson',$g->'cfb_wk13_sec_Wake Forest at Vanderbilt',$g->'cfb_wk13_sec_Kentucky at Tennessee',$g->'cfb_wk13_sec_Mississippi State at Mississippi') ); } // Call for Users Scores $sql2 = "SELECT 'cfb_wk1_acc_Florida A&M at Miami (FL)', 'cfb_wk1_acc_Presbyterian at Wake Forest', 'cfb_wk1_acc_Samford at Florida State', 'cfb_wk1_acc_South Carolina State at Georgia Tech', 'cfb_wk1_acc_Weber State at Boston College', 'cfb_wk1_acc_North Texas at Clemson', 'cfb_wk1_acc_Western Carolina at North Carolina State', 'cfb_wk1_acc_Richmond at Virginia', 'cfb_wk1_acc_Elon at Duke', 'cfb_wk1_acc_LSU vs. North Carolina', 'cfb_wk1_acc_Navy vs. Maryland', 'cfb_wk1_acc_Boise State vs. Virginia Tech', 'cfb_wk2_acc_Duke at Wake Forest', 'cfb_wk2_acc_Georgia Tech at Kansas', 'cfb_wk2_acc_James Madison at Virginia Tech', 'cfb_wk2_acc_Kent State at Boston College', 'cfb_wk2_acc_Florida State at Oklahoma', 'cfb_wk2_acc_Presbyterian at Clemson', 'cfb_wk2_acc_Miami (FL) at Ohio State', 'cfb_wk2_acc_Morgan State at Maryland', 'cfb_wk2_acc_North Carolina State at UCF', 'cfb_wk2_acc_Virginia at USC', 'cfb_wk3_acc_Cincinnati at North Carolina State', 'cfb_wk3_acc_Georgia Tech at North Carolina', 'cfb_wk3_acc_Maryland at West Virginia', 'cfb_wk3_acc_East Carolina at Virginia Tech', 'cfb_wk3_acc_Brigham Young at Florida State', 'cfb_wk3_acc_Alabama at Duke', 'cfb_wk3_acc_Clemson at Auburn', 'cfb_wk3_acc_Wake Forest at Stanford', 'cfb_wk4_acc_Miami (FL) at Pittsburgh', 'cfb_wk4_acc_Wake Forest at Florida State', 'cfb_wk4_acc_North Carolina State at Georgia Tech', 'cfb_wk4_acc_Virginia Tech at Boston College', 'cfb_wk4_acc_FIU at Maryland', 'cfb_wk4_acc_Army at Duke', 'cfb_wk4_acc_North Carolina at Rutgers', 'cfb_wk4_acc_Virginia Military Institute at Virginia', 'cfb_wk5_acc_Notre Dame at Boston College', 'cfb_wk5_acc_Duke at Maryland', 'cfb_wk5_acc_Virginia Tech at North Carolina State', 'cfb_wk5_acc_East Carolina at North Carolina', 'cfb_wk5_acc_Georgia Tech at Wake Forest', 'cfb_wk5_acc_Miami (FL) at Clemson', 'cfb_wk5_acc_Florida State at Virginia', 'cfb_wk6_acc_Virginia at Georgia Tech', 'cfb_wk6_acc_Boston College at North Carolina State', 'cfb_wk6_acc_Clemson at North Carolina', 'cfb_wk6_acc_Navy at Wake Forest', 'cfb_wk6_acc_Florida State at Miami (FL)', 'cfb_wk6_acc_Central Michigan at Virginia Tech', 'cfb_wk7_acc_Boston College at Florida State', 'cfb_wk7_acc_Middle Tennessee at Georgia Tech', 'cfb_wk7_acc_Miami (FL) at Duke', 'cfb_wk7_acc_North Carolina State at East Carolina', 'cfb_wk7_acc_Maryland at Clemson', 'cfb_wk7_acc_North Carolina at Virginia', 'cfb_wk7_acc_Wake Forest at Virginia Tech', 'cfb_wk8_acc_Maryland at Boston College', 'cfb_wk8_acc_Georgia Tech at Clemson', 'cfb_wk8_acc_Eastern Michigan at Virginia', 'cfb_wk8_acc_Duke at Virginia Tech', 'cfb_wk8_acc_North Carolina at Miami (FL)', 'cfb_wk9_acc_Florida State at North Carolina State', 'cfb_wk9_acc_Clemson at Boston College', 'cfb_wk9_acc_Wake Forest at Maryland', 'cfb_wk9_acc_William & Mary at North Carolina', 'cfb_wk9_acc_Miami (FL) at Virginia', 'cfb_wk9_acc_Duke at Navy', 'cfb_wk10_acc_Georgia Tech at Virginia Tech', 'cfb_wk10_acc_North Carolina at Florida State', 'cfb_wk10_acc_Virginia at Duke', 'cfb_wk10_acc_Boston College at Wake Forest', 'cfb_wk10_acc_North Carolina State at Clemson', 'cfb_wk10_acc_Maryland at Miami (FL)', 'cfb_wk11_acc_Clemson at Florida State', 'cfb_wk11_acc_Miami (FL) at Georgia Tech', 'cfb_wk11_acc_Boston College at Duke', 'cfb_wk11_acc_Wake Forest at North Carolina State', 'cfb_wk11_acc_Virginia Tech at North Carolina', 'cfb_wk11_acc_Maryland at Virginia', 'cfb_wk12_acc_Duke at Georgia Tech', 'cfb_wk12_acc_Virginia at Boston College', 'cfb_wk12_acc_Florida State at Maryland', 'cfb_wk12_acc_North Carolina State at North Carolina', 'cfb_wk12_acc_Clemson at Wake Forest', 'cfb_wk12_acc_Virginia Tech at Miami (FL)', 'cfb_wk13_acc_Florida at Florida State', 'cfb_wk13_acc_Georgia Tech at Georgia', 'cfb_wk13_acc_North Carolina State at Maryland', 'cfb_wk13_acc_North Carolina at Duke', 'cfb_wk13_acc_Boston College at Syracuse', 'cfb_wk13_acc_South Carolina at Clemson', 'cfb_wk13_acc_Wake Forest at Vanderbilt', 'cfb_wk13_acc_Virginia at Virginia Tech', 'cfb_wk13_acc_South Florida at Miami (FL)', 'cfb_wk1_sec_Southern Miss at South Carolina', 'cfb_wk1_sec_Arkansas State at Auburn', 'cfb_wk1_sec_Tennessee Tech at Arkansas', 'cfb_wk1_sec_Miami (OH) at Florida', 'cfb_wk1_sec_Louisiana-Lafayette at Georgia', 'cfb_wk1_sec_Jacksonville State at Mississippi', 'cfb_wk1_sec_Northwestern at Vanderbilt', 'cfb_wk1_sec_San Jose State at Alabama', 'cfb_wk1_sec_Memphis at Mississippi State', 'cfb_wk1_sec_Tennessee-Martin at Tennessee', 'cfb_wk1_sec_Kentucky at Louisville', 'cfb_wk1_sec_LSU vs. North Carolina', 'cfb_wk2_sec_Auburn at Mississippi State', 'cfb_wk2_sec_South Florida at Florida', 'cfb_wk2_sec_Western Kentucky at Kentucky', 'cfb_wk2_sec_LSU at Vanderbilt', 'cfb_wk2_sec_Arkansas vs. Louisiana-Monroe', 'cfb_wk2_sec_Georgia at South Carolina', 'cfb_wk2_sec_Penn State at Alabama', 'cfb_wk2_sec_Oregon at Tennessee', 'cfb_wk2_sec_Mississippi at Tulane', 'cfb_wk3_sec_Arkansas at Georgia', 'cfb_wk3_sec_Akron at Kentucky', 'cfb_wk3_sec_Vanderbilt at Mississippi', 'cfb_wk3_sec_Furman at South Carolina', 'cfb_wk3_sec_Alabama at Duke', 'cfb_wk3_sec_Florida at Tennessee', 'cfb_wk3_sec_Clemson at Auburn', 'cfb_wk3_sec_Mississippi State at LSU', 'cfb_wk4_sec_South Carolina at Auburn', 'cfb_wk4_sec_Alabama at Arkansas', 'cfb_wk4_sec_Kentucky at Florida', 'cfb_wk4_sec_Fresno State at Mississippi', 'cfb_wk4_sec_Georgia at Mississippi State', 'cfb_wk4_sec_UAB at Tennessee', 'cfb_wk4_sec_West Virginia at LSU', 'cfb_wk5_sec_Louisiana-Monroe at Auburn', 'cfb_wk5_sec_Vanderbilt at Connecticut', 'cfb_wk5_sec_Kentucky at Mississippi', 'cfb_wk5_sec_Florida at Alabama', 'cfb_wk5_sec_Alcorn State at Mississippi State', 'cfb_wk5_sec_Georgia at Colorado', 'cfb_wk5_sec_Tennessee at LSU', 'cfb_wk6_sec_LSU at Florida', 'cfb_wk6_sec_Tennessee at Georgia', 'cfb_wk6_sec_Auburn at Kentucky', 'cfb_wk6_sec_Eastern Michigan at Vanderbilt', 'cfb_wk6_sec_Arkansas vs. Texas A&M', 'cfb_wk6_sec_Alabama at South Carolina', 'cfb_wk6_sec_Mississippi State at Houston', 'cfb_wk7_sec_Arkansas at Auburn', 'cfb_wk7_sec_Mississippi State at Florida', 'cfb_wk7_sec_Vanderbilt at Georgia', 'cfb_wk7_sec_South Carolina at Kentucky', 'cfb_wk7_sec_Mississippi at Alabama', 'cfb_wk7_sec_McNeese State at LSU', 'cfb_wk8_sec_LSU at Auburn', 'cfb_wk8_sec_Mississippi at Arkansas', 'cfb_wk8_sec_Georgia at Kentucky', 'cfb_wk8_sec_South Carolina at Vanderbilt', 'cfb_wk8_sec_UAB at Mississippi State', 'cfb_wk8_sec_Alabama at Tennessee', 'cfb_wk9_sec_Vanderbilt at Arkansas', 'cfb_wk9_sec_Auburn at Mississippi', 'cfb_wk9_sec_Kentucky at Mississippi State', 'cfb_wk9_sec_Tennessee at South Carolina', 'cfb_wk9_sec_Florida vs. Georgia', 'cfb_wk10_sec_Chattanooga at Auburn', 'cfb_wk10_sec_Idaho State at Georgia', 'cfb_wk10_sec_Charleston Southern at Kentucky', 'cfb_wk10_sec_Louisiana-Lafayette at Mississippi', 'cfb_wk10_sec_Florida at Vanderbilt', 'cfb_wk10_sec_Arkansas at South Carolina', 'cfb_wk10_sec_Alabama at LSU', 'cfb_wk10_sec_Tennessee at Memphis', 'cfb_wk11_sec_Georgia at Auburn', 'cfb_wk11_sec_UTEP at Arkansas', 'cfb_wk11_sec_South Carolina at Florida', 'cfb_wk11_sec_Vanderbilt at Kentucky', 'cfb_wk11_sec_Mississippi State at Alabama', 'cfb_wk11_sec_Mississippi at Tennessee', 'cfb_wk11_sec_Louisiana-Monroe at LSU', 'cfb_wk12_sec_Appalachian State at Florida', 'cfb_wk12_sec_Tennessee at Vanderbilt', 'cfb_wk12_sec_Arkansas at Mississippi State', 'cfb_wk12_sec_Troy at South Carolina', 'cfb_wk12_sec_Georgia State at Alabama', 'cfb_wk12_sec_Mississippi at LSU', 'cfb_wk13_sec_Auburn at Alabama', 'cfb_wk13_sec_LSU at Arkansas', 'cfb_wk13_sec_Florida at Florida State', 'cfb_wk13_sec_Georgia Tech at Georgia', 'cfb_wk13_sec_South Carolina at Clemson', 'cfb_wk13_sec_Wake Forest at Vanderbilt', 'cfb_wk13_sec_Kentucky at Tennessee', 'cfb_wk13_sec_Mississippi State at Mississippi' FROM users WHERE id = $ids"; $result2 = mysql_query($sql2); while ($s = mysql_fetch_object($result2)) { $games_s_acc = array( array($s->'cfb_wk1_acc_Florida A&M at Miami (FL)',$s->'cfb_wk1_acc_Presbyterian at Wake Forest',$s->'cfb_wk1_acc_Samford at Florida State',$s->'cfb_wk1_acc_South Carolina State at Georgia Tech',$s->'cfb_wk1_acc_Weber State at Boston College',$s->'cfb_wk1_acc_North Texas at Clemson',$s->'cfb_wk1_acc_Western Carolina at North Carolina State',$s->'cfb_wk1_acc_Richmond at Virginia',$s->'cfb_wk1_acc_Elon at Duke',$s->'cfb_wk1_acc_LSU vs. North Carolina',$s->'cfb_wk1_acc_Navy vs. Maryland',$s->'cfb_wk1_acc_Boise State vs. Virginia Tech'), array($s->'cfb_wk2_acc_Duke at Wake Forest',$s->'cfb_wk2_acc_Georgia Tech at Kansas',$s->'cfb_wk2_acc_James Madison at Virginia Tech',$s->'cfb_wk2_acc_Kent State at Boston College',$s->'cfb_wk2_acc_Florida State at Oklahoma',$s->'cfb_wk2_acc_Presbyterian at Clemson',$s->'cfb_wk2_acc_Miami (FL) at Ohio State',$s->'cfb_wk2_acc_Morgan State at Maryland',$s->'cfb_wk2_acc_North Carolina State at UCF',$s->'cfb_wk2_acc_Virginia at USC'), array($s->'cfb_wk3_acc_Cincinnati at North Carolina State',$s->'cfb_wk3_acc_Georgia Tech at North Carolina',$s->'cfb_wk3_acc_Maryland at West Virginia',$s->'cfb_wk3_acc_East Carolina at Virginia Tech',$s->'cfb_wk3_acc_Brigham Young at Florida State',$s->'cfb_wk3_acc_Alabama at Duke',$s->'cfb_wk3_acc_Clemson at Auburn',$s->'cfb_wk3_acc_Wake Forest at Stanford'), array($s->'cfb_wk4_acc_Miami (FL) at Pittsburgh',$s->'cfb_wk4_acc_Wake Forest at Florida State',$s->'cfb_wk4_acc_North Carolina State at Georgia Tech',$s->'cfb_wk4_acc_Virginia Tech at Boston College',$s->'cfb_wk4_acc_FIU at Maryland',$s->'cfb_wk4_acc_Army at Duke',$s->'cfb_wk4_acc_North Carolina at Rutgers',$s->'cfb_wk4_acc_Virginia Military Institute at Virginia'), array($s->'cfb_wk5_acc_Notre Dame at Boston College',$s->'cfb_wk5_acc_Duke at Maryland',$s->'cfb_wk5_acc_Virginia Tech at North Carolina State',$s->'cfb_wk5_acc_East Carolina at North Carolina',$s->'cfb_wk5_acc_Georgia Tech at Wake Forest',$s->'cfb_wk5_acc_Miami (FL) at Clemson',$s->'cfb_wk5_acc_Florida State at Virginia'), array($s->'cfb_wk6_acc_Virginia at Georgia Tech',$s->'cfb_wk6_acc_Boston College at North Carolina State',$s->'cfb_wk6_acc_Clemson at North Carolina',$s->'cfb_wk6_acc_Navy at Wake Forest',$s->'cfb_wk6_acc_Florida State at Miami (FL)',$s->'cfb_wk6_acc_Central Michigan at Virginia Tech'), array($s->'cfb_wk7_acc_Boston College at Florida State',$s->'cfb_wk7_acc_Middle Tennessee at Georgia Tech',$s->'cfb_wk7_acc_Miami (FL) at Duke',$s->'cfb_wk7_acc_North Carolina State at East Carolina',$s->'cfb_wk7_acc_Maryland at Clemson',$s->'cfb_wk7_acc_North Carolina at Virginia',$s->'cfb_wk7_acc_Wake Forest at Virginia Tech'), array($s->'cfb_wk8_acc_Maryland at Boston College',$s->'cfb_wk8_acc_Georgia Tech at Clemson',$s->'cfb_wk8_acc_Eastern Michigan at Virginia',$s->'cfb_wk8_acc_Duke at Virginia Tech',$s->'cfb_wk8_acc_North Carolina at Miami (FL)'), array($s->'cfb_wk9_acc_Florida State at North Carolina State',$s->'cfb_wk9_acc_Clemson at Boston College',$s->'cfb_wk9_acc_Wake Forest at Maryland',$s->'cfb_wk9_acc_William & Mary at North Carolina',$s->'cfb_wk9_acc_Miami (FL) at Virginia',$s->'cfb_wk9_acc_Duke at Navy'), array($s->'cfb_wk10_acc_Georgia Tech at Virginia Tech',$s->'cfb_wk10_acc_North Carolina at Florida State',$s->'cfb_wk10_acc_Virginia at Duke',$s->'cfb_wk10_acc_Boston College at Wake Forest',$s->'cfb_wk10_acc_North Carolina State at Clemson',$s->'cfb_wk10_acc_Maryland at Miami (FL)'), array($s->'cfb_wk11_acc_Clemson at Florida State',$s->'cfb_wk11_acc_Miami (FL) at Georgia Tech',$s->'cfb_wk11_acc_Boston College at Duke',$s->'cfb_wk11_acc_Wake Forest at North Carolina State',$s->'cfb_wk11_acc_Virginia Tech at North Carolina',$s->'cfb_wk11_acc_Maryland at Virginia'), array($s->'cfb_wk12_acc_Duke at Georgia Tech',$s->'cfb_wk12_acc_Virginia at Boston College',$s->'cfb_wk12_acc_Florida State at Maryland',$s->'cfb_wk12_acc_North Carolina State at North Carolina',$s->'cfb_wk12_acc_Clemson at Wake Forest',$s->'cfb_wk12_acc_Virginia Tech at Miami (FL)'), array($s->'cfb_wk13_acc_Florida at Florida State',$s->'cfb_wk13_acc_Georgia Tech at Georgia',$s->'cfb_wk13_acc_North Carolina State at Maryland',$s->'cfb_wk13_acc_North Carolina at Duke',$s->'cfb_wk13_acc_Boston College at Syracuse',$s->'cfb_wk13_acc_South Carolina at Clemson',$s->'cfb_wk13_acc_Wake Forest at Vanderbilt',$s->'cfb_wk13_acc_Virginia at Virginia Tech',$s->'cfb_wk13_acc_South Florida at Miami (FL)') ); } while ($s = mysql_fetch_object($result2)) { $games_s_sec = array( array($s->'cfb_wk1_sec_Southern Miss at South Carolina',$s->'cfb_wk1_sec_Arkansas State at Auburn',$s->'cfb_wk1_sec_Tennessee Tech at Arkansas',$s->'cfb_wk1_sec_Miami (OH) at Florida',$s->'cfb_wk1_sec_Louisiana-Lafayette at Georgia',$s->'cfb_wk1_sec_Jacksonville State at Mississippi',$s->'cfb_wk1_sec_Northwestern at Vanderbilt',$s->'cfb_wk1_sec_San Jose State at Alabama',$s->'cfb_wk1_sec_Memphis at Mississippi State',$s->'cfb_wk1_sec_Tennessee-Martin at Tennessee',$s->'cfb_wk1_sec_Kentucky at Louisville',$s->'cfb_wk1_sec_LSU vs. North Carolina'), array($s->'cfb_wk2_sec_Auburn at Mississippi State',$s->'cfb_wk2_sec_South Florida at Florida',$s->'cfb_wk2_sec_Western Kentucky at Kentucky',$s->'cfb_wk2_sec_LSU at Vanderbilt',$s->'cfb_wk2_sec_Arkansas vs. Louisiana-Monroe',$s->'cfb_wk2_sec_Georgia at South Carolina',$s->'cfb_wk2_sec_Penn State at Alabama',$s->'cfb_wk2_sec_Oregon at Tennessee',$s->'cfb_wk2_sec_Mississippi at Tulane'), array($s->'cfb_wk3_sec_Arkansas at Georgia',$s->'cfb_wk3_sec_Akron at Kentucky',$s->'cfb_wk3_sec_Vanderbilt at Mississippi',$s->'cfb_wk3_sec_Furman at South Carolina',$s->'cfb_wk3_sec_Alabama at Duke',$s->'cfb_wk3_sec_Florida at Tennessee',$s->'cfb_wk3_sec_Clemson at Auburn',$s->'cfb_wk3_sec_Mississippi State at LSU'), array($s->'cfb_wk4_sec_South Carolina at Auburn',$s->'cfb_wk4_sec_Alabama at Arkansas',$s->'cfb_wk4_sec_Kentucky at Florida',$s->'cfb_wk4_sec_Fresno State at Mississippi',$s->'cfb_wk4_sec_Georgia at Mississippi State',$s->'cfb_wk4_sec_UAB at Tennessee',$s->'cfb_wk4_sec_West Virginia at LSU'), array($s->'cfb_wk5_sec_Louisiana-Monroe at Auburn',$s->'cfb_wk5_sec_Vanderbilt at Connecticut',$s->'cfb_wk5_sec_Kentucky at Mississippi',$s->'cfb_wk5_sec_Florida at Alabama',$s->'cfb_wk5_sec_Alcorn State at Mississippi State',$s->'cfb_wk5_sec_Georgia at Colorado',$s->'fb_wk5_sec_Tennessee at LSU'), array($s->'cfb_wk6_sec_LSU at Florida',$s->'cfb_wk6_sec_Tennessee at Georgia',$s->'cfb_wk6_sec_Auburn at Kentucky',$s->'cfb_wk6_sec_Eastern Michigan at Vanderbilt',$s->'cfb_wk6_sec_Arkansas vs. Texas A&M',$s->'cfb_wk6_sec_Alabama at South Carolina',$s->'cfb_wk6_sec_Mississippi State at Houston'), array($s->'cfb_wk7_sec_Arkansas at Auburn',$s->'cfb_wk7_sec_Mississippi State at Florida',$s->'cfb_wk7_sec_Vanderbilt at Georgia',$s->'cfb_wk7_sec_South Carolina at Kentucky',$s->'cfb_wk7_sec_Mississippi at Alabama',$s->'cfb_wk7_sec_McNeese State at LSU'), array($s->'cfb_wk8_sec_LSU at Auburn',$s->'cfb_wk8_sec_Mississippi at Arkansas',$s->'cfb_wk8_sec_Georgia at Kentucky',$s->'cfb_wk8_sec_South Carolina at Vanderbilt',$s->'cfb_wk8_sec_UAB at Mississippi State',$s->'cfb_wk8_sec_Alabama at Tennessee'), array($s->'cfb_wk9_sec_Vanderbilt at Arkansas',$s->'cfb_wk9_sec_Auburn at Mississippi',$s->'cfb_wk9_sec_Kentucky at Mississippi State',$s->'cfb_wk9_sec_Tennessee at South Carolina',$s->'cfb_wk9_sec_Florida vs. Georgia'), array($s->'cfb_wk10_sec_Chattanooga at Auburn',$s->'cfb_wk10_sec_Idaho State at Georgia',$s->'cfb_wk10_sec_Charleston Southern at Kentucky',$s->'cfb_wk10_sec_Louisiana-Lafayette at Mississippi',$s->'cfb_wk10_sec_Florida at Vanderbilt',$s->'cfb_wk10_sec_Arkansas at South Carolina',$s->'cfb_wk10_sec_Alabama at LSU',$s->'cfb_wk10_sec_Tennessee at Memphis'), array($s->'cfb_wk11_sec_Georgia at Auburn',$s->'cfb_wk11_sec_UTEP at Arkansas',$s->'cfb_wk11_sec_South Carolina at Florida',$s->'cfb_wk11_sec_Vanderbilt at Kentucky',$s->'cfb_wk11_sec_Mississippi State at Alabama',$s->'cfb_wk11_sec_Mississippi at Tennessee',$s->'cfb_wk11_sec_Louisiana-Monroe at LSU'), array($s->'cfb_wk12_sec_Appalachian State at Florida',$s->'cfb_wk12_sec_Tennessee at Vanderbilt',$s->'cfb_wk12_sec_Arkansas at Mississippi State',$s->'cfb_wk12_sec_Troy at South Carolina',$s->'cfb_wk12_sec_Georgia State at Alabama',$s->'cfb_wk12_sec_Mississippi at LSU'), array($s->'cfb_wk13_sec_Auburn at Alabama',$s->'cfb_wk13_sec_LSU at Arkansas',$s->'cfb_wk13_sec_Florida at Florida State',$s->'cfb_wk13_sec_Georgia Tech at Georgia',$s->'cfb_wk13_sec_South Carolina at Clemson',$s->'cfb_wk13_sec_Wake Forest at Vanderbilt',$s->'cfb_wk13_sec_Kentucky at Tennessee',$s->'cfb_wk13_sec_Mississippi State at Mississippi') ); } // Start of Scoring for($i=0; $i< count($games_g_acc); $i++){ $sql3 = "SELECT 'cfb_points','cfb_acc_points','cfb_sec_points' FROM users WHERE id = $ids"; $result3 = mysql_query($sql3); while ($current_score = mysql_fetch_object($result3)) { $user_score_overall = ($current_score->cfb_points); $user_score_acc = ($current_score->cfb_acc_points); $user_score_sec = ($current_score->cfb_sec_points); } $final_acc = $games_g_acc[$i]; //This is the Admin Array (Final Scores) $picks_acc = $games_s_acc[$i]; $sort_final_acc = $final_acc; $sort_picks_acc = $picks_acc; $final_values_acc = array_values($final_acc); $picks_values_acc = array_values($picks_acc); array_multisort($sort_final_acc,SORT_ASC); array_multisort ($sort_picks_acc,SORT_ASC); $final_sort_values_acc = array_values($sort_final_acc); $picks_sort_values_acc = array_values($sort_picks_acc); $matches_acc = array_intersect($final_values_acc, $picks_values_acc); if ($final_values_acc == $picks_values_acc) { $points = ("100"); $award = ($user_score_acc + $points); $query = "UPDATE users SET cfb_acc_points='$award' WHERE id = '$ids'"; mysql_query ($query); } elseif ($matches_acc) { $number = sizeof($matches_acc); $points = ("10"); $pointsMatches = ($number * $points); $award = ($user_score_acc + $pointsMatches); echo $pointsMatches; $query = "UPDATE users SET cfb_acc_points='$award' WHERE id = '$ids'"; mysql_query ($query); } else{ } } } //Function Done ?> <?php for($i=0; $i< count($ids); $i++) { cfbPicks($ids[$i]); } echo "Scores Updated"; mysql_close(); exit(); ?> Quote Link to comment Share on other sites More sharing options...
gizmola Posted July 23, 2010 Share Posted July 23, 2010 What type of error? Quote Link to comment Share on other sites More sharing options...
shlumph Posted July 23, 2010 Share Posted July 23, 2010 Do you really have fields in your DB like 'cfb_wk13_sec_Mississippi State at Mississippi'? It must have been tedious writing all that out, huh? Quote Link to comment Share on other sites More sharing options...
Lucky2710 Posted July 23, 2010 Author Share Posted July 23, 2010 The script when ran just displays a white blank page. Its not working. And yes my field in DB are that, It only took about 2 hours. Quote Link to comment Share on other sites More sharing options...
tomtimms Posted July 23, 2010 Share Posted July 23, 2010 Your errors begin below line $games_g_acc = array( Quote Link to comment Share on other sites More sharing options...
gizmola Posted July 23, 2010 Share Posted July 23, 2010 In the future, you want to look at your error log. It should tell you what the syntax error is. Quote Link to comment Share on other sites More sharing options...
Mchl Posted July 23, 2010 Share Posted July 23, 2010 OK... Your database is suffering from 'spreadsheet syndrome'. You're using relational database management system as if it was Excel. Please read this article http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html before you go any further with this application. Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted July 23, 2010 Share Posted July 23, 2010 Your white page is being caused by a fatal error. You should be learning php, developing php code, and debugging php code on a system with error_reporting set to E_ALL and display_errors set to ON in your master php.ini so that php will report and display all the errors it detects. You will save a ton of time. As to your database design and writing out all that repetitious code and data. Computers were designed to help with repetitive tasks. If you find yourself repeating line after line of code that only differs in the name of a variable or in the actual data value, you should be using a loop to simplify your code. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.