Jump to content

Lucky2710

Members
  • Posts

    119
  • Joined

  • Last visited

    Never

Everything posted by Lucky2710

  1. When you view source it shows this.... <h3><em style="color: #F00"> <?php echo $wk;?> <?php echo $wknum;?> </em></h3> <form name="Picks" method="post" action="<?php echo $process; ?>"> <p><br> <input name="P0" type="hidden" value="<?php echo ($p[0]); ?>"> <label> <input type="radio" name="game1" value="<?php echo ($away[0]);?>" > <?php echo ($away[0]);?></label> at <label> <input type="radio" name="game1" value="<?php echo ($home[0]);?>" > <?php echo ($home[0]);?></label> <br> <input name="P1" type="hidden" value="<?php echo ($p[1]); ?>"> <label> <input type="radio" name="game2" value="<?php echo ($away[1]);?>" > <?php echo ($away[1]);?></label> at <label> <input type="radio" name="game2" value="<?php echo ($home[1]);?>" > <?php echo ($home[1]);?></label> <br> <input name="P2" type="hidden" value="<?php echo ($p[2]); ?>"> <label> <input type="radio" name="game3" value="<?php echo ($away[2]);?>" > <?php echo ($away[2]);?></label> at <label> <input type="radio" name="game3" value="<?php echo ($home[2]);?>" > <?php echo ($home[2]);?></label> <br> <input name="P3" type="hidden" value="<?php echo ($p[3]); ?>"> <label> <input type="radio" name="game4" value="<?php echo ($away[3]);?>" > <?php echo ($away[3]);?> </label> at <label> <input type="radio" name="game4" value="<?php echo ($home[3]);?>" > <?php echo ($home[3]);?></label> <input name="P4" type="hidden" value="<?php echo ($p[4]); ?>"> <br> <label> <input type="radio" name="game5" value="<?php echo ($away[4]);?>" > <?php echo ($away[4]);?></label> at <label> <input type="radio" name="game5" value="<?php echo ($home[4]);?>" > <?php echo ($home[4]);?></label> <br> <input name="P5" type="hidden" value="<?php echo ($p[5]); ?>"> <label> <input type="radio" name="game6" value="<?php echo ($away[5]);?>" > <?php echo ($away[5]);?></label> at <label> <input type="radio" name="game6" value="<?php echo ($home[5]);?>" > <?php echo ($home[5]);?></label> <br> <input name="P6" type="hidden" value="<?php echo ($p[6]); ?>"> <label> <input type="radio" name="game7" value="<?php echo ($away[6]);?>" > <?php echo ($away[6]);?></label> at <label> <input type="radio" name="game7" value="<?php echo ($home[6]);?>" > <?php echo ($home[6]);?></label> <br> <input name="P7" type="hidden" value="<?php echo ($p[7]); ?>"> <label> <input type="radio" name="game8" value="<?php echo ($away[7]);?>" > <?php echo ($away[7]);?></label> at <label> <input type="radio" name="game8" value="<?php echo ($home[7]);?>" > <?php echo ($home[7]);?></label> <br> <input name="P8" type="hidden" value="<?php echo ($p[8]); ?>"> <label> <input type="radio" name="game9" value="<?php echo ($away[8]);?>" > <?php echo ($away[8]);?> </label> at <label> <input type="radio" name="game9" value="<?php echo ($home[8]);?>" > <?php echo ($home[8]);?></label> <br> <input name="P9" type="hidden" value="<?php echo ($p[9]); ?>"> <label> <input type="radio" name="game10" value="<?php echo ($away[9]);?>" > <?php echo ($away[9]);?> </label> at <label> <input type="radio" name="game10" value="<?php echo ($home[9]);?>" > <?php echo ($home[9]);?></label> <br> <input name="P10" type="hidden" value="<?php echo ($p[10]); ?>"> <label> <input type="radio" name="game11" value="<?php echo ($away[10]);?>" > <?php echo ($away[10]);?></label> at <label> <input type="radio" name="game11" value="<?php echo ($home[10]);?>" > <?php echo ($home[10]);?></label> <br> <input name="P11" type="hidden" value="<?php echo ($p[11]); ?>"> <label> <input type="radio" name="game12" value="<?php echo ($away[11]);?>" > <?php echo ($away[11]);?></label> at <label> <input type="radio" name="game12" value="<?php echo ($home[11]);?>" > <?php echo ($home[11]);?></label> <br> <br> <label> <input type="reset" name="button" id="button" value="Reset"> </label> <label> <input type="submit" name="button2" id="button2" value="Submit"> </label> <br> </p> </form> Which means that for some reason or another its not processing the <?php ?> stuff! Anybody know why?
  2. The are a bunch of free decent shopping carts all ready built and ready to just insert into your web site. It would save you a lot of time just to use one of those. Check this site out http://gscripts.net/free-php-scripts/Shopping_Carts.html
  3. I have all error reporting turned on. And no errors are showing. I've been staring at this code for 2 hours and can't find the error. But the form is blank! The form shows up with the radio buttons but is blank! Heres the code... <?php error_reporting(E_ALL); ?> <?php include 'dbc.php'; //----------------------------------------- $result = mysql_query("SELECT * FROM users ORDER BY nc_points DESC"); while ($row = mysql_fetch_object($result)) { $leaderboard[] = $row->user_name; $leaderboardPoints[] = $row->cfb_points; } $result1 = mysql_query("SELECT CollegeFootballGames.ID, CollegeFootballGames.Week, CollegeFootballGames.Away, CollegeFootballGames.Home, CollegeFootballTeams.Team FROM CollegeFootballGames INNER JOIN CollegeFootballTeams ON CollegeFootballGames.Away = CollegeFootballTeams.ID || CollegeFootballGames.Home=CollegeFootballTeams.ID"); while ($row = mysql_fetch_object($result1)) { $GameID[] = $row->ID; $Teams[] = $row->Team; } //---------------------------------------- $date =("now"); if ( strtotime($date) > strtotime('18 July 2010') && strtotime($date) < strtotime('2 September 2010')){$wknum = '1'; $wk = "Week";} elseif ( strtotime($date) > strtotime('6 September 2010') && strtotime($date) < strtotime('11 September 2010')){$wknum = '2'; $wk = "Week";} elseif ( strtotime($date) > strtotime('11 September 2010') && strtotime($date) < strtotime('16 September 2010')){$wknum = '3'; $wk = "Week";} elseif ( strtotime($date) > strtotime('18 September 2010') && strtotime($date) < strtotime('23 September 2010')){$wknum = '4'; $wk = "Week";} elseif ( strtotime($date) > strtotime('25 September 2010') && strtotime($date) < strtotime('2 October 2010')){$wknum = '5'; $wk = "Week";} elseif ( strtotime($date) > strtotime('2 October 2010') && strtotime($date) < strtotime('9 October 2010')){$wknum = '6'; $wk = "Week";} elseif ( strtotime($date) > strtotime('9 October 2010') && strtotime($date) < strtotime('16 October 2010')){$wknum = '7'; $wk = "Week";} elseif ( strtotime($date) > strtotime('16 October 2010') && strtotime($date) < strtotime('23 October 2010')){$wknum = '8'; $wk = "Week";} elseif ( strtotime($date) > strtotime('23 October 2010') && strtotime($date) < strtotime('28 October 2010')){$wknum = '9'; $wk = "Week";} elseif ( strtotime($date) > strtotime('30 October 2010') && strtotime($date) < strtotime('4 November 2010')){$wknum = '10'; $wk = "Week";} elseif ( strtotime($date) > strtotime('6 November 2010') && strtotime($date) < strtotime('13 November 2010')){$wknum = '11'; $wk = "Week";} elseif ( strtotime($date) > strtotime('13 November 2010') && strtotime($date) < strtotime('20 November 2010')){$wknum = '12'; $wk = "Week";} elseif ( strtotime($date) > strtotime('20 November 2010') && strtotime($date) < strtotime('27 November 2010')){$wknum = '13'; $wk = "Week";} else{} //Form 12 $form12 = ('<h3><em style="color: #F00"> <?php echo $wk;?> <?php echo $wknum;?> </em></h3> <form name="Picks" method="post" action="<?php echo $process; ?>"> <p><br> <input name="P0" type="hidden" value="<?php echo ($p[0]); ?>"> <label> <input type="radio" name="game1" value="<?php echo ($away[0]);?>" > <?php echo ($away[0]);?></label> at <label> <input type="radio" name="game1" value="<?php echo ($home[0]);?>" > <?php echo ($home[0]);?></label> <br> <input name="P1" type="hidden" value="<?php echo ($p[1]); ?>"> <label> <input type="radio" name="game2" value="<?php echo ($away[1]);?>" > <?php echo ($away[1]);?></label> at <label> <input type="radio" name="game2" value="<?php echo ($home[1]);?>" > <?php echo ($home[1]);?></label> <br> <input name="P2" type="hidden" value="<?php echo ($p[2]); ?>"> <label> <input type="radio" name="game3" value="<?php echo ($away[2]);?>" > <?php echo ($away[2]);?></label> at <label> <input type="radio" name="game3" value="<?php echo ($home[2]);?>" > <?php echo ($home[2]);?></label> <br> <input name="P3" type="hidden" value="<?php echo ($p[3]); ?>"> <label> <input type="radio" name="game4" value="<?php echo ($away[3]);?>" > <?php echo ($away[3]);?> </label> at <label> <input type="radio" name="game4" value="<?php echo ($home[3]);?>" > <?php echo ($home[3]);?></label> <input name="P4" type="hidden" value="<?php echo ($p[4]); ?>"> <br> <label> <input type="radio" name="game5" value="<?php echo ($away[4]);?>" > <?php echo ($away[4]);?></label> at <label> <input type="radio" name="game5" value="<?php echo ($home[4]);?>" > <?php echo ($home[4]);?></label> <br> <input name="P5" type="hidden" value="<?php echo ($p[5]); ?>"> <label> <input type="radio" name="game6" value="<?php echo ($away[5]);?>" > <?php echo ($away[5]);?></label> at <label> <input type="radio" name="game6" value="<?php echo ($home[5]);?>" > <?php echo ($home[5]);?></label> <br> <input name="P6" type="hidden" value="<?php echo ($p[6]); ?>"> <label> <input type="radio" name="game7" value="<?php echo ($away[6]);?>" > <?php echo ($away[6]);?></label> at <label> <input type="radio" name="game7" value="<?php echo ($home[6]);?>" > <?php echo ($home[6]);?></label> <br> <input name="P7" type="hidden" value="<?php echo ($p[7]); ?>"> <label> <input type="radio" name="game8" value="<?php echo ($away[7]);?>" > <?php echo ($away[7]);?></label> at <label> <input type="radio" name="game8" value="<?php echo ($home[7]);?>" > <?php echo ($home[7]);?></label> <br> <input name="P8" type="hidden" value="<?php echo ($p[8]); ?>"> <label> <input type="radio" name="game9" value="<?php echo ($away[8]);?>" > <?php echo ($away[8]);?> </label> at <label> <input type="radio" name="game9" value="<?php echo ($home[8]);?>" > <?php echo ($home[8]);?></label> <br> <input name="P9" type="hidden" value="<?php echo ($p[9]); ?>"> <label> <input type="radio" name="game10" value="<?php echo ($away[9]);?>" > <?php echo ($away[9]);?> </label> at <label> <input type="radio" name="game10" value="<?php echo ($home[9]);?>" > <?php echo ($home[9]);?></label> <br> <input name="P10" type="hidden" value="<?php echo ($p[10]); ?>"> <label> <input type="radio" name="game11" value="<?php echo ($away[10]);?>" > <?php echo ($away[10]);?></label> at <label> <input type="radio" name="game11" value="<?php echo ($home[10]);?>" > <?php echo ($home[10]);?></label> <br> <input name="P11" type="hidden" value="<?php echo ($p[11]); ?>"> <label> <input type="radio" name="game12" value="<?php echo ($away[11]);?>" > <?php echo ($away[11]);?></label> at <label> <input type="radio" name="game12" value="<?php echo ($home[11]);?>" > <?php echo ($home[11]);?></label> <br> <br> <label> <input type="reset" name="button" id="button" value="Reset"> </label> <label> <input type="submit" name="button2" id="button2" value="Submit"> </label> <br> </p> </form>'); if ( strtotime($date) > strtotime('18 July 2010') && strtotime($date) < strtotime('2 September 2010')){$wknum = '1'; $formDisplay = $form12; $wk = "Week"; $process = 'cfb_picks_process.php'; $away =array("$Teams[0]","$Teams[2]","$Teams[4]","$Teams[6]","$Teams[8]","$Teams[10]","$Teams[12]","$Teams[14]","$Teams[16]","$Teams[18]","$Teams[20]","$Teams[22]"); $home =array("$Teams[1]","$Teams[3]","$Teams[5]","$Teams[7]","$Teams[9]","$Teams[11]","$Teams[13]","$Teams[15]","$Teams[17]","$Teams[19]","$Teams[21]","$Teams[23]"); $p = array ("$GameID[0]","$GameID[2]","$GameID[4]","$GameID[6]","$GameID[8]","$GameID[10]","$GameID[12]","$GameID[14]","$GameID[16]","$GameID[18]","$GameID[20]","$GameID[22]");} elseif ( strtotime($date) > strtotime('6 September 2010') && strtotime($date) < strtotime('11 September 2010')){$wknum = '2';$formDisplay = $form12; $wk = "Week";$process = 'cfb_picks_process.php'; $away =array("$Teams[24]","$Teams[26]","$Teams[28]","$Teams[30]","$Teams[33]","$Teams[34]","$Teams[36]","$Teams[38]","$Teams[40]","$Teams[42]","$Teams[44]","$Teams[46]"); $home =array("$Teams[25]","$Teams[27]","$Teams[29]","$Teams[31]","$Teams[32]","$Teams[35]","$Teams[37]","$Teams[39]","$Teams[41]","$Teams[43]","$Teams[45]","$Teams[47]"); $p = array ("$GameID[24]","$GameID[26]","$GameID[28]","$GameID[30]","$GameID[32]","$GameID[34]","$GameID[36]","$GameID[38]","$GameID[40]","$GameID[42]","$GameID[44]","$GameID[46]"); } elseif ( strtotime($date) > strtotime('11 September 2010') && strtotime($date) < strtotime('16 September 2010')){$wknum = '3';$formDisplay = $form12; $wk = "Week";$process = 'cfb_picks_process.php'; $away =array("$Teams[49]","$Teams[50]","$Teams[52]","$Teams[55]","$Teams[56]","$Teams[58]","$Teams[61]","$Teams[62]","$Teams[64]","$Teams[66]","$Teams[68]","$Teams[70]"); $home =array("$Teams[48]","$Teams[51]","$Teams[53]","$Teams[54]","$Teams[57]","$Teams[59]","$Teams[60]","$Teams[63]","$Teams[65]","$Teams[67]","$Teams[69]","$Teams[71]"); $p = array ("$GameID[48]","$GameID[50]","$GameID[52]","$GameID[54]","$GameID[56]","$GameID[58]","$GameID[60]","$GameID[62]","$GameID[64]","$GameID[66]","$GameID[68]","$GameID[70]"); } elseif ( strtotime($date) > strtotime('18 September 2010') && strtotime($date) < strtotime('23 September 2010')){$wknum = '4';$formDisplay = $form12; $wk = "Week";$process = 'cfb_picks_process.php'; $away =array("$Teams[72]","$Teams[74]","$Teams[76]","$Teams[78]","$Teams[80]","$Teams[83]","$Teams[85]","$Teams[87]","$Teams[88]","$Teams[91]","$Teams[92]","$Teams[94]"); $home =array("$Teams[73]","$Teams[75]","$Teams[77]","$Teams[79]","$Teams[81]","$Teams[82]","$Teams[84]","$Teams[86]","$Teams[89]","$Teams[90]","$Teams[93]","$Teams[95]"); $p = array ("$GameID[72]","$GameID[74]","$GameID[76]","$GameID[78]","$GameID[80]","$GameID[82]","$GameID[84]","$GameID[86]","$GameID[88]","$GameID[90]","$GameID[92]","$GameID[94]"); } elseif ( strtotime($date) > strtotime('25 September 2010') && strtotime($date) < strtotime('2 October 2010')){$wknum = '5';$formDisplay = $form12; $wk = "Week";$process = 'cfb_picks_process.php'; /*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]"); */} elseif ( strtotime($date) > strtotime('2 October 2010') && strtotime($date) < strtotime('9 October 2010')){$wknum = '6';$formDisplay = $form12; $wk = "Week";$process = 'cfb_picks_process.php'; /*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]"); */} elseif ( strtotime($date) > strtotime('9 October 2010') && strtotime($date) < strtotime('16 October 2010')){$wknum = '7';$formDisplay = $form12;$wk = "Week";$process = 'cfb_picks_process.php'; /*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]"); */} elseif ( strtotime($date) > strtotime('16 October 2010') && strtotime($date) < strtotime('23 October 2010')){$wknum = '8';$formDisplay = $form12;$wk = "Week";$process = 'cfb_picks_process.php'; /*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]"); */} elseif ( strtotime($date) > strtotime('23 October 2010') && strtotime($date) < strtotime('28 October 2010')){$wknum = '9';$formDisplay = $form12;$wk = "Week";$process = 'cfb_picks_process.php'; /*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]"); */} elseif ( strtotime($date) > strtotime('30 October 2010') && strtotime($date) < strtotime('4 November 2010')){$wknum = '10';$formDisplay = $form12;$wk = "Week";$process = 'cfb_picks_process.php'; /*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]"); */} elseif ( strtotime($date) > strtotime('6 November 2010') && strtotime($date) < strtotime('13 November 2010')){$wknum = '11';$formDisplay = $form12;$wk = "Week";$process = 'cfb_picks_process.php'; /*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]"); */} elseif ( strtotime($date) > strtotime('13 November 2010') && strtotime($date) < strtotime('20 November 2010')){$wknum = '12';$formDisplay = $form12;$wk = "Week";$process = 'cfb_picks_process.php'; /*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]"); */} elseif ( strtotime($date) > strtotime('20 November 2010') && strtotime($date) < strtotime('27 November 2010')){$wknum = '13';$formDisplay = $form12;$wk = "Week";$process = 'cfb_picks_process.php'; /*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); $p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]"); */} else{$formDisplay = $wk = " "; $formDisplay = ("<br><br><h2>Picks For this week are final!</h2> <br><br><br> Check Back Later To Make Your Picks For Next Week");} $result = mysql_query("SELECT * FROM users ORDER BY nc_points DESC"); while ($row = mysql_fetch_object($result)) { $leaderboard[] = $row->user_name; $leaderboardPoints[] = $row->cfb_points; } $result1 = mysql_query("SELECT CollegeFootballGames.ID, CollegeFootballGames.Week, CollegeFootballGames.Away, CollegeFootballGames.Home, CollegeFootballTeams.Team FROM CollegeFootballGames INNER JOIN CollegeFootballTeams ON CollegeFootballGames.Away = CollegeFootballTeams.ID || CollegeFootballGames.Home=CollegeFootballTeams.ID"); while ($row = mysql_fetch_object($result1)) { $GameID[] = $row->ID; $Teams[] = $row->Team; } ?> <? echo $formDisplay; ?> If you see what is wrong please tell me.
  4. Ive got a form and its got groups of 2 radio buttons. when its submitted i need somehow to attach certain information to each radio group. The form is taking user info and putting it into mysql, so the hidden info has to go somehow. Like i need the users choice to be submitted and with that choice i need the game id for that choice. I can figure out the mysql on my own i just cant seem to make hidden info go through the way i want it too. Can any one help. below is part of the code. <form action="testprocess.php" method="post"> <p> <label> <input name="F" type="hidden" value="Game 1" id="RadioGroup1_0"></label> <label> <input type="radio" name="F" value="Florida" id="RadioGroup1_1"> Florida</label> <label> <input type="radio" name="F" value="Florida State" id="RadioGroup1_2"> Florida St</label> </p> <p> <label> <input name="SC" type="hidden" value="Game 2" id="RadioGroup2_0"></label> <label> <input type="radio" name="SC" value="South Carolina" id="RadioGroup2_1"> South Carolina</label> <label> <input type="radio" name="SC" value="Clemson" id="RadioGroup2_3"> Clemson</label> <br> </p> <input name="" type="submit" value="Submit"></form> <?php $F = $_POST[F]; $SC = $_POST[sC]; ?> <?php echo $F; echo'<br />'; echo $SC; ?> The code ive posted is just a basic un-cluttered version of my actual script. (Note it has NO my sql) Any help is greatly appreciated!
  5. Well dang it would make my code less confusing! cause im using dbs with a bunch of #s!
  6. $result1 = mysql_query("SELECT CollegeFootballGames.ID, CollegeFootballGames.Week, CollegeFootballGames.Away, CollegeFootballGames.Home, CollegeFootballTeams.Team FROM CollegeFootballGames INNER JOIN CollegeFootballTeams ON CollegeFootballGames.Away = CollegeFootballTeams.ID || CollegeFootballGames.Home=CollegeFootballTeams.ID"); while ($row = mysql_fetch_object($result1)) { $GameID[] = $row->ID; $Teams[] = $row->Team;
  7. This might be a dumb question but it would be helpful. Is there anyway to make an array not start at "0"?
  8. I have 4 tables "a users table" "a teams table" "a games table" and "a picks table" Tables are set up like this... Games Teams Picks Users - ID - ID - ID - id - Week - Team - User_ID - full_name - Away - Game_ID - user_name - Home - Pick - password My issue is getting the data from the multiple tables at one time. Like i need to pull from teams the team name into games (away and home) each team has a different id and in the games table in the way spot is that teams id. so how do u pull the team name depending on what is in the away field. If i can figure that out i can figure the rest out on my own. but i dont have a clue how to do that major starting place. My plan is to use php to echo the data onto the page. Thanks for any help i can get! Server version is 5.1.42 Client Version is 5.1.37 Apache/2.0.52 (Red Hat)
  9. Thanks im gonna look deeper into that
  10. well like i said im new to this and i asked for help with a problem, not for somebody to say thats inefficient code. O well!!! If you were going to elaborate on a better way, i wouldn't have been a jerk. If your not gonna help don't post a reply.
  11. Well im pretty new to php and thats the way I know, so unless your gonna elaborate onto a more efficient way. That wasn't what I asked ,I asked for help in a help forum, not for an opinion of my code by somebody who thinks they know it all.
  12. On my web site I have users, each user has his/her individual profile. Currently in the profile its just information like name, user name, favorites, ect. (Information Stuff) I want to add the feature of profile image. (Pictures associated with each profile) But i want the pics to only be able to be seen associated with that person (I dont want you to be able to get the images exact url and be able to get that pic off the internet) So what is the best way to do it? Is there a way to put the pics in mySQL? XML? Other Option? What's your opinion?
  13. Lucky2710

    Help

    Heres my current code... <?php //---------------------------------------- $date =("17 October 2010"); if ( strtotime($date) > strtotime('18 July 2010') && strtotime($date) < strtotime('2 September 2010')){$wknum = '1'; $wk = "Week";} elseif ( strtotime($date) > strtotime('6 September 2010') && strtotime($date) < strtotime('11 September 2010')){$wknum = '2'; $wk = "Week";} elseif ( strtotime($date) > strtotime('11 September 2010') && strtotime($date) < strtotime('16 September 2010')){$wknum = '3'; $wk = "Week";} elseif ( strtotime($date) > strtotime('18 September 2010') && strtotime($date) < strtotime('23 September 2010')){$wknum = '4'; $wk = "Week";} elseif ( strtotime($date) > strtotime('25 September 2010') && strtotime($date) < strtotime('2 October 2010')){$wknum = '5'; $wk = "Week";} elseif ( strtotime($date) > strtotime('2 October 2010') && strtotime($date) < strtotime('9 October 2010')){$wknum = '6'; $wk = "Week";} elseif ( strtotime($date) > strtotime('9 October 2010') && strtotime($date) < strtotime('16 October 2010')){$wknum = '7'; $wk = "Week";} elseif ( strtotime($date) > strtotime('16 October 2010') && strtotime($date) < strtotime('23 October 2010')){$wknum = '8'; $wk = "Week";} elseif ( strtotime($date) > strtotime('23 October 2010') && strtotime($date) < strtotime('28 October 2010')){$wknum = '9'; $wk = "Week";} elseif ( strtotime($date) > strtotime('30 October 2010') && strtotime($date) < strtotime('4 November 2010')){$wknum = '10'; $wk = "Week";} elseif ( strtotime($date) > strtotime('6 November 2010') && strtotime($date) < strtotime('13 November 2010')){$wknum = '11'; $wk = "Week";} elseif ( strtotime($date) > strtotime('13 November 2010') && strtotime($date) < strtotime('20 November 2010')){$wknum = '12'; $wk = "Week";} elseif ( strtotime($date) > strtotime('20 November 2010') && strtotime($date) < strtotime('27 November 2010')){$wknum = '13'; $wk = "Week";} else{$formDisplay = $wk = " "; } //Form 5 $form5 = ('<h3><em style="color: #F00"> <?php echo $wk;?> <?php echo $wknum;?> </em></h3> <form name="Picks" method="post" action="<?php echo $process; ?>"> <p><br> <label> <input name="ACC_Game_ID1" type="hidden" value="<php echo ($id[0]); ?>"> <input type="radio" name="game1" value="<?php echo ($away[0]);?>" > <?php echo ($away[0]);?></label> at <label> <input type="radio" name="game1" value="<?php echo ($home[0]);?>" > <?php echo ($home[0]);?></label> <br> <label> <input name="ACC_Game_ID2" type="hidden" value="<php echo ($id[1]); ?>"> <input type="radio" name="game2" value="<?php echo ($away[1]);?>" > <?php echo ($away[1]);?></label> at <label> <input type="radio" name="game2" value="<?php echo ($home[1]);?>" > <?php echo ($home[1]);?></label> <br> <label> <input name="ACC_Game_ID3" type="hidden" value="<php echo ($id[2]); ?>"> <input type="radio" name="game3" value="<?php echo ($away[2]);?>" > <?php echo ($away[2]);?></label> at <label> <input type="radio" name="game3" value="<?php echo ($home[2]);?>" > <?php echo ($home[2]);?></label> <br> <label> <input name="ACC_Game_ID4" type="hidden" value="<php echo ($id[3]); ?>"> <input type="radio" name="game4" value="<?php echo ($away[3]);?>" > <?php echo ($away[3]);?> </label> at <label> <input type="radio" name="game4" value="<?php echo ($home[3]);?>" > <?php echo ($home[3]);?></label> <br> <label> <input name="ACC_Game_ID5" type="hidden" value="<php echo ($id[4]); ?>"> <input type="radio" name="game5" value="<?php echo ($away[4]);?>" > <?php echo ($away[4]);?></label> at <label> <input type="radio" name="game5" value="<?php echo ($home[4]);?>" > <?php echo ($home[4]);?></label> <br> <br> <label> <input type="reset" name="button" id="button" value="Reset"> </label> <label> <input type="submit" name="button2" id="button2" value="Submit"> </label> <br> </p> </form>'); if ( strtotime($date) > strtotime('18 July 2010') && strtotime($date) < strtotime('2 September 2010')){$wknum = '1'; $formDisplay = $form12; $wk = "Week"; $process = 'cfb_acc_picks_process.php';} elseif ( strtotime($date) > strtotime('6 September 2010') && strtotime($date) < strtotime('11 September 2010')){$wknum = '2';$formDisplay = $form10; $wk = "Week";$process = 'cfb_acc_picks_process.php';$ACC_Game_ID= $id;} elseif ( strtotime($date) > strtotime('11 September 2010') && strtotime($date) < strtotime('16 September 2010')){$wknum = '3';$formDisplay = $form8; $wk = "Week";$process = 'cfb_acc_picks_process.php';$ACC_Game_ID= $id;} elseif ( strtotime($date) > strtotime('18 September 2010') && strtotime($date) < strtotime('23 September 2010')){$wknum = '4';$formDisplay = $form8; $wk = "Week";$process = 'cfb_acc_picks_process.php';$ACC_Game_ID= $id;} elseif ( strtotime($date) > strtotime('25 September 2010') && strtotime($date) < strtotime('2 October 2010')){$wknum = '5';$formDisplay = $form7; $wk = "Week";$process = 'cfb_acc_picks_process.php';$ACC_Game_ID= $id;} elseif ( strtotime($date) > strtotime('2 October 2010') && strtotime($date) < strtotime('9 October 2010')){$wknum = '6';$formDisplay = $form6; $wk = "Week";$process = 'cfb_acc_picks_process.php';$ACC_Game_ID= $id;} elseif ( strtotime($date) > strtotime('9 October 2010') && strtotime($date) < strtotime('16 October 2010')){$wknum = '7';$formDisplay = $form7;$wk = "Week";$process = 'cfb_acc_picks_process.php';$ACC_Game_ID= $id;} elseif ( strtotime($date) > strtotime('16 October 2010') && strtotime($date) < strtotime('23 October 2010')){$wknum = '8';$formDisplay = $form5;$wk = "Week";$process = 'cfb_acc_picks_process.php';$ACC_Game_ID= $id;} elseif ( strtotime($date) > strtotime('23 October 2010') && strtotime($date) < strtotime('28 October 2010')){$wknum = '9';$formDisplay = $form6;$wk = "Week";$process = 'cfb_acc_picks_process.php';$ACC_Game_ID= $id;} elseif ( strtotime($date) > strtotime('30 October 2010') && strtotime($date) < strtotime('4 November 2010')){$wknum = '10';$formDisplay = $form6;$wk = "Week";$process = 'cfb_acc_picks_process.php';$ACC_Game_ID= $id;} elseif ( strtotime($date) > strtotime('6 November 2010') && strtotime($date) < strtotime('13 November 2010')){$wknum = '11';$formDisplay = $form6;$wk = "Week";$process = 'cfb_acc_picks_process.php';$ACC_Game_ID= $id;} elseif ( strtotime($date) > strtotime('13 November 2010') && strtotime($date) < strtotime('20 November 2010')){$wknum = '12';$formDisplay = $form6;$wk = "Week";$process = 'cfb_acc_picks_process.php';$ACC_Game_ID= $id;} elseif ( strtotime($date) > strtotime('20 November 2010') && strtotime($date) < strtotime('27 November 2010')){$wknum = '13';$formDisplay = $form9;$wk = "Week";$process = 'cfb_acc_picks_process.php';$ACC_Game_ID= $id;} else{$formDisplay = $wk = " "; $formDisplay = ("<br><br><h2>Picks For this week are final!</h2> <br><br><br> Check Back Later To Make Your Picks For Next Week");} $result = mysql_query("SELECT * FROM ACC_Games_Table WHERE Week_Number='$wknum'"); while ($row = mysql_fetch_object($result)) { $away[] = $row->Away; $home[] = $row->Home; } $result = mysql_query("SELECT * FROM ACC_Games_Table WHERE Away='$away'"); while ($row = mysql_fetch_object($result)) { $id[] = $row->ACC_Game_ID; } Heres my purpose... Depending on the date it shows different forms. And also depending on the week number it shows different match ups. Hers my problem... I need for with each match up (it to be hidden on the form but still attached for later mysql stuff) the games id number. I need help with somehow depending on the teams determine what the game id is (because when the form is processed im going to pull the id number with which team was picked to be published to a mysql table). mySQL tables ---------------- ACC_Games_Table Fields ------ ACC_Game_ID Week_Number Away Home CFB_Picks_Table Fields ------ Pick_ID User_ID ACC_Game_ID User_Pick Thanks
  14. i have a form that i only want to display between certain dates. So I'm calling a variable with the form inside it. but parts of the form are php controlled. am i going to have to echo all the html or is there a way to put php inside html inside the variable. Heres my code so u can see what I'm trying to do. $form = ('<h3><em style="color: #F00"> <?php echo $wk;?> <?php echo $wknum;?> </em></h3> <form name="ACC_wk1" method="post" action="cfb_acc_picks_process.php"> <p><br> <label> <input type="radio" name="game1" value="<?php echo ($away[0]);?>" "> <?php echo ($away[0]);?></label> at <label> <input type="radio" name="game1" value="<?php echo ($home[0]);?>" > <?php echo ($home[0]);?></label> <br> <label> <input type="radio" name="game2" value="<?php echo ($away[1]);?>" > <?php echo ($away[1]);?></label> at <label> <input type="radio" name="game2" value="<?php echo ($home[1]);?>" > <?php echo ($home[1]);?></label> </p> <p> <label> <input type="radio" name="game3" value="<?php echo ($away[2]);?>" > <?php echo ($away[2]);?></label> at <label> <input type="radio" name="game3" value="<?php echo ($home[2]);?>" > <?php echo ($home[2]);?></label> <br> <label> <input type="radio" name="game4" value="<?php echo ($away[3]);?>" > <?php echo ($away[3]);?> </label> at <label> <input type="radio" name="game4" value="<?php echo ($home[3]);?>" > <?php echo ($home[3]);?></label> <br> <label> <input type="radio" name="game5" value="<?php echo ($away[4]);?>" > <?php echo ($away[4]);?></label> at <label> <input type="radio" name="game5" value="<?php echo ($home[4]);?>" > <?php echo ($home[4]);?></label> <br> <label> <input type="radio" name="game6" value="<?php echo ($away[5]);?>" > <?php echo ($away[5]);?></label> at <label> <input type="radio" name="game6" value="<?php echo ($home[5]);?>" > <?php echo ($home[5]);?></label> <br> <label> <input type="radio" name="game7" value="<?php echo ($away[6]);?>" > <?php echo ($away[6]);?></label> at <label> <input type="radio" name="game7" value="<?php echo ($home[6]);?>" > <?php echo ($home[6]);?></label> <br> <label> <input type="radio" name="game8" value="<?php echo ($away[7]);?>" > <?php echo ($away[7]);?></label> at <label> <input type="radio" name="game8" value="<?php echo ($home[11]);?>" > <?php echo ($home[7]);?></label> <br> <label> <input type="radio" name="game9" value="<?php echo ($away[8]);?>" > <?php echo ($away[8]);?> </label> at <label> <input type="radio" name="game9" value="<?php echo ($home[11]);?>" > <?php echo ($home[8]);?></label> <br> <label> <input type="radio" name="game10" value="<?php echo ($away[9]);?>" > <?php echo ($away[9]);?> </label> at <label> <input type="radio" name="game10" value="<?php echo ($home[11]);?>" > <?php echo ($home[9]);?></label> <br> <label> <input type="radio" name="game11" value="<?php echo ($away[10]);?>" > <?php echo ($away[10]);?></label> at <label> <input type="radio" name="game11" value="<?php echo ($home[11]);?>" > <?php echo ($home[10]);?></label> <br> <label> <input type="radio" name="game12" value="<?php echo ($away[11]);?>" > <?php echo ($away[11]);?></label> at <label> <input type="radio" name="game12" value="<?php echo ($home[11]);?>" > <?php echo ($home[11]);?></label> <br> <br> <label> <input type="reset" name="button" id="button" value="Reset"> </label> <label> <input type="submit" name="button2" id="button2" value="Submit"> </label> <br> </p> </form>'); $date =("now"); if ( strtotime($date) > strtotime('18 July 2010') && strtotime($date) < strtotime('2 September 2010')){$wknum = '1'; $formDisplay = $form; $wk = "Week";} elseif ( strtotime($date) > strtotime('6 September 2010') && strtotime($date) < strtotime('11 September 2010')){$wknum = '2';$formDisplay = $form; $wk = "Week";} elseif ( strtotime($date) > strtotime('11 September 2010') && strtotime($date) < strtotime('16 September 2010')){$wknum = '3';$formDisplay = $form; $wk = "Week";} elseif ( strtotime($date) > strtotime('18 September 2010') && strtotime($date) < strtotime('23 September 2010')){$wknum = '4';$formDisplay = $form; $wk = "Week";} elseif ( strtotime($date) > strtotime('25 September 2010') && strtotime($date) < strtotime('2 October 2010')){$wknum = '5';$formDisplay = $form; $wk = "Week";} elseif ( strtotime($date) > strtotime('2 October 2010') && strtotime($date) < strtotime('9 October 2010')){$wknum = '6';$formDisplay = $form; $wk = "Week";} elseif ( strtotime($date) > strtotime('9 October 2010') && strtotime($date) < strtotime('16 October 2010')){$wknum = '7';$formDisplay = $form;$wk = "Week";} elseif ( strtotime($date) > strtotime('16 October 2010') && strtotime($date) < strtotime('23 October 2010')){$wknum = '8';$formDisplay = $form;$wk = "Week";} elseif ( strtotime($date) > strtotime('23 October 2010') && strtotime($date) < strtotime('28 October 2010')){$wknum = '9';$formDisplay = $form;$wk = "Week";} elseif ( strtotime($date) > strtotime('30 October 2010') && strtotime($date) < strtotime('4 November 2010')){$wknum = '10';$formDisplay = $form;$wk = "Week";} elseif ( strtotime($date) > strtotime('6 November 2010') && strtotime($date) < strtotime('13 November 2010')){$wknum = '11';$formDisplay = $form;$wk = "Week";} elseif ( strtotime($date) > strtotime('13 November 2010') && strtotime($date) < strtotime('20 November 2010')){$wknum = '12';$formDisplay = $form;$wk = "Week";} elseif ( strtotime($date) > strtotime('20 November 2010') && strtotime($date) < strtotime('27 November 2010')){$wknum = '13';$formDisplay = $form;$wk = "Week";} else{$formDisplay = $wk = " "; $formDisplay = ("<br><br><h2>Picks For this week are final!</h2> <br><br><br> Check Back Later To Make Your Picks For Next Week");} $result = mysql_query("SELECT * FROM ACC_Games_Table WHERE Week_Number='$wknum'"); while ($row = mysql_fetch_object($result)) { $away[] = $row->Away; $home[] = $row->Home; } Thanks
  15. Now that i figured out Error reporting Heres my error. But What does it mean??? Object of class stdClass could not be converted to string
  16. 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.
  17. 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(); ?>
  18. Original $game8DB = ('cfb_wk13_acc_Virginia at Virginia Tech'); $game9 = $_POST[game9]; $game9DB = ('cfb_wk13_acc_South Florida at Miami (FL)'); } else{ } } else{ } ?> //I GOT RID OF THIS <?php //AND I GOT RID OF THIS mysql_connect ("localhost","user","pass"); mysql_select_db ("sports"); $query = "UPDATE users SET `$game1DB`='$game1', `$game2DB`='$game2', `$game3DB`='$game3', `$game4DB`='$game4', I just got rid of it being separate and what do you know it worked!
  19. I changed the bottom code to WHERE id = '$userid'"; mysql_query ($query); mysql_close(); ?> <?php $URL="http://sports.nodinelandscaping.com/phplogin_v2.3/Home.php"; header ("Location: $URL"); exit(); ?> And it still aint workin. But if i put <?php $URL="http://sports.nodinelandscaping.com/phplogin_v2.3/Home.php"; header ("Location: $URL"); exit(); ?> in by itself it works! So I dont know??? There has to be a way to get this workin! Or Some other way.
  20. But data IS posting to mySQL so i thinks it below the query.
  21. The script is broken up into 3 main parts. 1. Getting the post data depending on date 2. taking POST data and inserting into mySQL 3. Going to home page
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.