cmb

i have it set up so the user picks the year and session and then the database shows all the games in that specific year and session and then displays them with a link to their photo galleria and also shows the record(wins - losses - ties) but the way i have it know its not displaying the first result here is the code <?php //declares $y as year played and $s as session $y = ' '; $s = ' '; //handles submition of form for picking year and session if (isset($_POST['submit'])) { $data = mysql_real_escape_string($_POST['session']); $exploeded = explode(",", $data); $y = $exploeded[0]; $s = $exploeded[1]; } //Query for the selection menu $squery = "SELECT DISTINCT(Year_Played), Sessions FROM pinkpanther_games"; $sresults = mysql_query($squery) or die("squery failed ($squery) - " . mysql_error()); //checks $y and $s to see if their is a vaule if ($y == ' '){$y = '20112012';} if ($s == ' '){$s = '2';} //Query for getting record and for getting all the appropriate info for displaying the games $query = " SELECT (SELECT COUNT(id) FROM pinkpanther_games WHERE Year_Played = $y AND Sessions = $s AND Win_Loss = 'Tie' ) AS 'Tie', (SELECT COUNT(id) FROM pinkpanther_games WHERE Year_Played = $y AND Sessions = $s AND Win_Loss = 'Win') AS 'Win', (SELECT COUNT(id) FROM pinkpanther_games WHERE Year_Played = $y AND Sessions = $s AND Win_Loss = 'Loss') AS 'Lose', Opponent AS Opponent, Score AS Score, Gallery_no AS Gal, Win_Loss AS Record FROM pinkpanther_games WHERE Year_Played = $y AND Sessions = $s"; $results = mysql_query($query) or die("Query failed ($query) - " . mysql_error()); $row_a = mysql_fetch_assoc($results); //Set record variables $wins = $row_a['Win']; $loss = $row_a['Lose']; $tie = $row_a['Tie']; //creates from and selection menu for year and session echo "<tr><td colspan='2'><form method='post' action=''><select name='session' class='txtbox2'>"; while ($srow = mysql_fetch_assoc($sresults)){ echo "<option value='" . $srow['Year_Played'] . "," . $srow['Sessions'] . "'>" . $srow['Year_Played'] . " Session " . $srow['Sessions'] . "</option>"; } echo "</select><input type='submit' name='submit' value='Go' class='txtbox2' /></form></td></tr>"; //displays record echo "<tr><td colspan='2'>" .$wins . " - " . $loss . " - " . $tie . "</td></tr>"; echo "<tr></tr>"; //displays games and scores in appropriate year and session while ($row = mysql_fetch_assoc($results)){ $opp = $row['Opponent']; $score = $row['Score']; $gal = $row['Gal']; $wlt = $row['Record']; //styles games acording to if win lose or tie if ($wlt == 'Win'){ echo "<tr><td class='win'>"; echo "<a href='galleries.php?g=$gal'" . $gal . " >" . $opp . "</a>"; echo "</td><td class='win'>"; echo $score . ""; echo "</td></tr>"; } if ($wlt == 'Loss'){ echo "<tr><td class='loss'>"; echo "<a href='galleries.php?g=$gal'" . $gal . " >" . $opp . "</a>"; echo "</td><td class='loss'>"; echo $score . ""; echo "</td></tr>"; } if ($wlt == 'Tie'){ echo "<tr><td class='tie'>"; echo "<a href='galleries.php?g=$gal'" . $gal . " >" . $opp . "</a>"; echo "</td><td class='tie'>"; echo $score . ""; echo "</td></tr>"; } } ?>

this is the while loop i use <?php while ($mm_wsi_row = mysql_fetch_assoc($wsi_result)){ echo $mm_wsi_row['yards'] . " hrank " . $mm_wsi_row['hrank'] . " lrank " . $mm_wsi_row['lrank']; echo "<br />"; } ?> and when it runs this is the resuts 1700 hrank 10 lrank 2 2200 hrank 9 lrank 3 2500 hrank 8 lrank 4 2600 hrank 7 lrank 5 2800 hrank 6 lrank 6 3000 hrank 5 lrank 7 3100 hrank 4 lrank 8 3300 hrank 3 lrank 9 3700 hrank 2 lrank 10 4100 hrank 1 lrank 11 here is a link to the actual page in use if u want to see http://swimming.photosbychristian.com/index.php

i don't think either of those things are the problem because the query works fine for the other 6 variables and some of the other data coming to the page uses the same varaible and its correct and idk about the privileges thing how could i test for that

yes thats excatly what im saying and i did copy and paste except for were i changed the Season = '' i put the variable in its place

i uploaded it my site and now only the season 6 doesn't work and also i found that when the query runs and i output all the data in a while loop this is what i get 1700 hrank 10 lrank 2 2200 hrank 9 lrank 3 2500 hrank 8 lrank 4 2600 hrank 7 lrank 5 2800 hrank 6 lrank 6 3000 hrank 5 lrank 7 3100 hrank 4 lrank 8 3300 hrank 3 lrank 9 3700 hrank 2 lrank 10 4100 hrank 1 lrank 11 it's missing this "1300 hrnank 11 lrank 1" and thats why im not getting the min but why would it do this

if "|" represents a new record then try this SELECT config FROM inettuts WHERE user_id = '5' AND config != 'Twitter,color-grey,Twitter,not-collapsed'

also i just tested to see what is actually being returned by the php so i added this to my query to limit the results to the 2 i actually care about "WHERE Season = '$ws' AND (hrank = '1' OR lrank = '1')" and used this while statement <?php while ($mm_wsi_row = mysql_fetch_assoc($wsi_result)){ echo $mm_wsi_row['yards']; } ?> and it only returns 1 value instead of 2 like it's suppose and when i run the same thing (replacing $ws with 6) in workbench i get 2 results

when i put season = 6 these are the records it brings back which is correct and it doesn't show the min only the max in the php also when season = 1 the same thing happens idk if its important but seasons start at 0 and go to 6 yards;date;season;totalyard;avg;timelaps;hrank;lrank 1300;2011-11-18;6;22500;2500.0000;9;9;1 1700;2011-11-19;6;22500;2500.0000;9;8;2 2200;2011-11-21;6;22500;2500.0000;9;7;3 2500;2011-11-22;6;22500;2500.0000;9;6;4 3000;2011-11-23;6;22500;2500.0000;9;3;7 3300;2011-11-25;6;22500;2500.0000;9;1;9 2800;2011-11-26;6;22500;2500.0000;9;4;6 3100;2011-11-29;6;22500;2500.0000;9;2;8 2600;2011-11-28;6;22500;2500.0000;9;5;5

this is my query code <?php $wsi_query = "(SELECT * FROM (SELECT a.no_Yards AS 'yards', a.Day_Swam AS 'date', a.Season AS 'season', (SELECT sum(no_yards) FROM swimming WHERE Season = '$ws') AS 'totalyards', (SELECT AVG(no_Yards) FROM swimming WHERE Season = '$ws') AS 'avg', (SELECT count(*) FROM swimming WHERE Season ='$ws') AS 'timelaps', (SELECT 1 + count(*) FROM swimming b WHERE b.no_Yards > a.no_Yards AND Season = '$ws') AS hrank, (SELECT 1 + count(*) FROM swimming b WHERE b.no_Yards < a.no_Yards AND Season = '$ws') AS lrank FROM swimming AS a) AS x WHERE Season = '$ws' )"; $wsi_result = mysql_query($wsi_query) or die("Query failed ($wsi_query) - " . mysql_error()); $wsi_row = mysql_fetch_assoc($wsi_result); ?> what it should do is output both the min and the max values like this <?php while ($mm_wsi_row = mysql_fetch_assoc($wsi_result)){ if ($mm_wsi_row['hrank'] == 1){ if ($mm_wsi_row['date'] == "0000-00-00"){$dayswam = "";}else{$dayswam = $mm_wsi_row['date'];} echo "<tr>"; echo "<td style='background-color:#F90'>Max Length:</td>"; echo "<td>" . number_format($mm_wsi_row['yards']) . "</td>"; echo "<td>" . $dayswam . "</td>"; echo "</tr>"; } if($mm_wsi_row['lrank'] == 1){ if ($mm_wsi_row['date'] == "0000-00-00"){$dayswam = "";}else{$dayswam = $mm_wsi_row['date'];} echo"<tr>"; echo "<td style='background-color:#F90'>Min Length:</td>"; echo "<td style='background-color:#FF9'>". number_format($mm_wsi_row['yards']) . "</td>"; echo "<td style='background-color:#FF9'>" . $dayswam . "</td>"; echo "</tr>"; } ?> the problem is that it doesn't work right all the time for some it just shows the min while others it just shows max I've tested the query in MySQL workbench so i know that that is working right but idk why it works right for some and doesn't work for others

my final query SELECT * FROM (SELECT a.no_Yards AS 'yards', a.Day_Swam AS 'date', a.Season AS 'season', (SELECT sum(no_yards) FROM swimming WHERE Season = '6') AS 'totalyard', (SELECT AVG(no_Yards) FROM swimming WHERE Season = '6') AS 'avg', (SELECT count(*) FROM swimming WHERE Season ='6') AS 'timelaps', (SELECT 1 + count(*) FROM swimming b WHERE b.no_Yards > a.no_Yards AND Season = '6') AS hrank, (SELECT 1 + count(*) FROM swimming b WHERE b.no_Yards < a.no_Yards AND Season = '6') AS lrank FROM swimming AS a) AS x WHERE Season = '6' AND (hrank = '1' OR lrank = '1')

i got this for my max query but idk how to get the min value select * from (select a.no_Yards as yards, a.Day_Swam as 'date', a.Season as season, (select 1 + count(*) from swimming b where b.no_Yards > a.no_Yards and Season = '5') as rank from swimming as a) as x where Season = '5' and x.rank = '1'

this is my query SELECT SUM(no_Yards) AS 'yards', AVG(no_yards) AS 'avg', MAX(no_Yards) AS 'max', MIN(no_Yards) AS 'min' FROM swimming WHERE Season = '$ws' and when i display the data i want to display the date that the max and the min happened (from the database in the column Day_Swam) something like this <?php echo "<tr>"; echo "<td style='background-color:#F90'>Max Length:</td>"; echo "<td>" . number_format($wsi_row['max']) . "</td>"; echo "<td>" . DATE WOULD GO HERE . "</td>"; echo "</tr>"; echo "</tr><tr>"; echo "<td style='background-color:#F90'>Min Length:</td>"; echo "<td style='background-color:#FF9'>" . number_format($wsi_row['min']) . "</td>"; echo "<td>" . DATE WOULD GO HERE . "</td>"; echo "</tr>"; ?>

i want to do some thing like this select sum(`no_Yards`) from `swimming` where `Season` = '0' only i want to sum the same colum no_Yards 6 different ways only changing the Season from 0 to 1 (and so on) something like this select sum(`no_Yards`) from `swimming` where `Season` = '0' select sum(`no_Yards`) from `swimming` where `Season` = '1' while only running 1 query but getting 6 different answers

I have this php page that based on what the user chooses shows them the appropriate photo galleria and i was wondering if their was any way i could speed this up this is the php code for selecting the galleria and I'm not showing the javascript that does the slide show because it s the galleriffic jquery plugin <div id="Info"> <div id="page"> <div id="container"> <?php $g = mysql_real_escape_string($_GET['g']); $query = "SELECT * FROM pinkpanther_games WHERE Gallery_no = '$g'"; $results = mysql_query($query) or die("Query failed ($_query) - " . mysql_error()); $row = mysql_fetch_assoc($results); echo "<h1>" . $row['Day_Played'] . " vs " . $row['Opponent'] . "</h1>"; ?> <!-- Start Advanced Gallery Html Containers --> <div id="gallery" class="content"> <div id="controls" class="controls"></div> <div class="slideshow-container"> <div id="loading" class="loader"></div> <div id="slideshow" class="slideshow"></div> </div> <div id="caption" class="caption-container"></div> </div> <div id="thumbs" class="navigation"> <ul class="thumbs noscript"> <?php $x = $row['no_Pics']; $y = 1; $year = $row['Year_Played']; $day = $row['Day_Played']; $scheck = $row['Sessions']; if ($scheck == 1){ $sessions = "Session1"; }else{ $sessions = "Session2"; } if ($x == 0){ echo "<li> <a class='thumb' href='../images/nopics.jpg' title=''><img src='../images/nopicsthumb.jpg ' /></a></li>"; }else if ($x == 10000){ echo "<li> <a class='thumb' href='../images/coming.jpg' title=''><img src='../images/comingthumb.jpg ' /></a></li>"; }else{ while ($y <= $x){ echo "<li> <a class='thumb' href='../images/Sections/pinkpanthers/" . $year . "/" . $sessions . "/" . $day . "/" . $y . ".jpg' title=''><img src='../images/Sections/pinkpanthers/" . $year . "/" . $sessions . "/" . $day . "/thumbs/" . $y . ".jpg ' /></a><div class='caption'><div class='download'><a href='../images/Sections/pinkpanthers/" . $year . "/" . $sessions . "/" . $day . "/big/" . $y . ".jpg ' target='_blank' />Download</a></div></div></li>"; $y ++ ; } } ?> </ul> </div> <div style="clear: both;"></div> </div> </div> <div id="footer"></div>

No i saw it, it didn't help me at all, i already new that you cant have anything output before a header but i don't and that's why I'm confused as to why its not working

on all my secured pages at the the very top the code is <?php require ("u_check_login.php"); ?> and then the u_check_login.php code is <?php require('database.php'); //Include DB connection information $ip = mysql_real_escape_string($_SERVER["REMOTE_ADDR"]); //Get user's IP Address $email = mysql_real_escape_string($_COOKIE['uemail']); //Get username stored in cookie $pp = mysql_real_escape_string($_COOKIE['pp']); if ($pp == 1){ $sessionid = mysql_real_escape_string($_COOKIE['sessionid']); //Get user's session ID $check = mysql_query("SELECT * FROM `users` WHERE `email` = '$email' AND `session_id` = '$sessionid' AND `login_ip` = '$ip' AND `pp` = '1' ") or die(mysql_error()); //Check if all information provided from the user is valid by checking in the DB $answer = mysql_num_rows($check); //Return number of results found. Equal to 0 if not logged in or 1 if logged in. if ($answer == 0 || $sessionid == '') { //Check if login is valid. If not redirect user to login page header('Location: ulogin.php'); exit(); } $row = mysql_fetch_array($check); $email = stripslashes($row['email']); }else{ header('Location: ulogin.php'); } ?> and this error is being displayed on my page that is supposed to not have let me on because i was not logged in Warning: Cannot modify header information - headers already sent by (output started at /home/content/03/8587103/html/pinkpanthers/pinkpanthers.php:1) in /home/content/03/8587103/html/pinkpanthers/u_check_login.php on line 17

Ok so this is the table that i want to be populated whit the data retrieved from the database <table width="483" height="320" border="0"> <tr> <td colspan="4">View Stats For:<?php if ($adam_view_numrows > 0){ echo "<form id='adam_go' method='post' action=''><select name='adam_statview' id='adam_statview' size='1' class='txtbox'>"; while ($adam_view_row = mysql_fetch_assoc($adam_view_results)){ $adam_games = $adam_view_row['Day_Played']; echo "<option value='" . $adam_games . "'>" . $adam_games ."</option>"; } echo "</select><input type='submit' value='Go' name='adam_go' id='adam_go' /></form>"; }else{ echo "<select name='adam_statview' id='adam_statview' size='1' class='txtbox'><option value='#'>No Stats Avalable </option></select>"; } ?></td> </tr> <tr> <td width="182">Goalie:</td> <td width="62"><input type="text" id="adam_goalie" name="adam_goalie" size="1" readonly class="txtbox" value="<?php echo $adam_goalie ?>" /></td> <td width="170">GLI:</td> <td width="51"><input type="text" id="adam_gli" name="adam_gli" size="1" readonly class="txtbox" value="<?php echo $adam_gli?>" /></td> </tr> <tr> <td>Goals:</td> <td><input type="text" id="adam_goals" name="adam_goals" size="1" readonly class="txtbox" value="<?php echo $adam_goals?>" /></td> <td>Saves:</td> <td><input type="text" id="adam_saves" name="adam_saves" size="1" readonly class="txtbox" value="<?php echo $adam_saves?>" /></td> </tr> <tr> <td>SOG:</td> <td><input type="text" id="adam_sog" name="adam_sog" size="1" readonly class="txtbox" value="<?php echo $adam_sog?>" /></td> <td>Assists:</td> <td><input type="text" id="adam_assists" name="adam_assists" size="1" readonly class="txtbox" value="<?php echo $adam_assists?>" /></td> </tr> <tr> <td>CK:</td> <td><input type="text" id="adam_fouls" name="adam_fouls" size="1" readonly class="txtbox" value="<?php echo $adam_ck?>" /></td> <td>YC:</td> <td><input type="text" id="adam_yc" name="adam_yc" size="1" readonly class="txtbox" value="<?php echo $adam_yc?>" /></td> </tr> <tr> <td>RC:</td> <td><input type="text" id="adam_rc" name="adam_rc" size="1" readonly class="txtbox" value="<?php echo $adam_rc?>" /></td> <td></td> <td></td> </tr> </table> so i guess im not understanding i should just change all this to genaric names and put it in a while loop would that do what im trying to acomplish and will the selection of which stats to view still work that way and im only 16 im still in high school

do you have any suggestions on how i should do this i know very little

this is my sql code <?php $query = "SELECT Player, SUM(GLI) AS 'gli', SUM(Goals) AS 'goals', SUM(Saves) AS 'saves', SUM(SOG) AS 'sog', SUM(Assists) AS'assists', SUM(CK) AS 'ck', SUM(YC) AS 'yc', SUM(RC) AS 'rc' FROM pinkpanther_stats GROUP BY Player; "; ?> their are 11 separate players and i want to set variables $adam_glie and $tyler_glie equal to the glie column for that player(the player being the first part of the variable) and i dont have any idea how to go about doing this

So when i use this code for the 10 other players having the generic names like $query or $results wont affect the results for the other players because they are all being viewed on the same page <?php $query = "SELECT Player, SUM(GLI) AS 'gli', SUM(Goals) AS 'goals', SUM(Saves) AS 'saves', SUM(SOG) AS 'sog', SUM(Assists) AS'assists', SUM(CK) AS 'ck', SUM(YC) AS 'yc', SUM(RC) AS 'rc' FROM pinkpanther_stats WHERE Player IN('Adam') GROUP BY Player; "; $results = mysql_query($query); $row = mysql_fetch_array($results); $adam_gli = $row[1]; $adam_goals = $row[2]; $adam_saves = $row[3]; $adam_sog = $row[4]; $adam_assists = $row[5]; $adam_ck = $row[6]; $adam_yc = $row[7]; $adam_rc = $row[8]; $adam_goalie = ""; ?>

this is my script it gets the values form the database and adds them and saves it to a variable which is then echoed to the user before i typed this code 10 more times changing every variable name i was wondering if their was a more efficient way of doing this <?php $adam_view_query = "SELECT * FROM pinkpanther_stats WHERE Player = 'Adam' ORDER BY Day_Played DESC"; $adam_view_results = mysql_query($adam_view_query) or die("Query failed ($adam_view_query) - " . mysql_error()); $adam_view_numrows = mysql_num_rows($adam_view_results); $adam_gli_query = "SELECT SUM(GLI) AS 'adam_gli' FROM pinkpanther_stats WHERE Player = 'Adam'"; $adam_gli_results = mysql_query($adam_gli_query) or die ("Query failed ($adam_gli_query) - " . mysql_error()); $adam_gli_row = mysql_fetch_array($adam_gli_results); $adam_gli = $adam_gli_row['adam_gli']; $adam_goals_query = "SELECT SUM(Goals) AS 'adam_goals' FROM pinkpanther_stats WHERE Player = 'Adam'"; $adam_goals_results = mysql_query($adam_goals_query) or die ("Query failed ($adam_goals_query) - " . mysql_error()); $adam_goals_row = mysql_fetch_array($adam_goals_results); $adam_goals = $adam_goals_row['adam_goals']; $adam_saves_query = "SELECT SUM(Saves) AS 'adam_saves' FROM pinkpanther_stats WHERE Player = 'Adam'"; $adam_saves_results = mysql_query($adam_saves_query) or die ("Query failed ($adam_saves_query) - " . mysql_error()); $adam_saves_row = mysql_fetch_array($adam_saves_results); $adam_saves = $adam_saves_row['adam_saves']; $adam_sog_query = "SELECT SUM(SOG) AS 'adam_sog' FROM pinkpanther_stats WHERE Player = 'Adam'"; $adam_sog_results = mysql_query($adam_sog_query) or die ("Query failed ($adam_sog_query) - " . mysql_error()); $adam_sog_row = mysql_fetch_array($adam_sog_results); $adam_sog = $adam_sog_row['adam_sog']; $adam_assists_query = "SELECT SUM(Assists) AS 'adam_assists' FROM pinkpanther_stats WHERE Player = 'Adam'"; $adam_assists_results = mysql_query($adam_assists_query) or die ("Query failed ($adam_assists_query) - " . mysql_error()); $adam_assists_row = mysql_fetch_array($adam_assists_results); $adam_assists = $adam_assists_row['adam_assists']; $adam_ck_query = "SELECT SUM(CK) AS 'adam_ck' FROM pinkpanther_stats WHERE Player = 'Adam'"; $adam_ck_results = mysql_query($adam_ck_query) or die ("Query failed ($adam_ck_query) - " . mysql_error()); $adam_ck_row = mysql_fetch_array($adam_ck_results); $adam_ck = $adam_ck_row['adam_ck']; $adam_yc_query = "SELECT SUM(YC) AS 'adam_yc' FROM pinkpanther_stats WHERE Player = 'Adam'"; $adam_yc_results = mysql_query($adam_yc_query) or die ("Query failed ($adam_yc_query) - " . mysql_error()); $adam_yc_row = mysql_fetch_array($adam_yc_results); $adam_yc = $adam_yc_row['adam_yc']; $adam_rc_query = "SELECT SUM(RC) AS 'adam_rc' FROM pinkpanther_stats WHERE Player = 'Adam'"; $adam_rc_results = mysql_query($adam_rc_query) or die ("Query failed ($adam_rc_query) - " . mysql_error()); $adam_rc_row = mysql_fetch_array($adam_rc_results); $adam_rc = $adam_rc_row['adam_rc']; $adam_goalie = ""; if (isset($_POST['adam_go'])) { $adam_view = mysql_real_escape_string($_POST['adam_statview']); if ($adam_view == "Total"){ $adam_gli_query = "SELECT SUM(GLI) AS 'adam_gli' FROM pinkpanther_stats WHERE Player = 'Adam'"; $adam_gli_results = mysql_query($adam_gli_query) or die ("Query failed ($adam_gli_query) - " . mysql_error()); $adam_gli_row = mysql_fetch_array($adam_gli_results); $adam_gli = $adam_gli_row['adam_gli']; $adam_goals_query = "SELECT SUM(Goals) AS 'adam_goals' FROM pinkpanther_stats WHERE Player = 'Adam'"; $adam_goals_results = mysql_query($adam_goals_query) or die ("Query failed ($adam_goals_query) - " . mysql_error()); $adam_goals_row = mysql_fetch_array($adam_goals_results); $adam_goals = $adam_goals_row['adam_goals']; $adam_saves_query = "SELECT SUM(Saves) AS 'adam_saves' FROM pinkpanther_stats WHERE Player = 'Adam'"; $adam_saves_results = mysql_query($adam_saves_query) or die ("Query failed ($adam_saves_query) - " . mysql_error()); $adam_saves_row = mysql_fetch_array($adam_saves_results); $adam_saves = $adam_saves_row['adam_saves']; $adam_sog_query = "SELECT SUM(SOG) AS 'adam_sog' FROM pinkpanther_stats WHERE Player = 'Adam'"; $adam_sog_results = mysql_query($adam_sog_query) or die ("Query failed ($adam_sog_query) - " . mysql_error()); $adam_sog_row = mysql_fetch_array($adam_sog_results); $adam_sog = $adam_sog_row['adam_sog']; $adam_assists_query = "SELECT SUM(Assists) AS 'adam_assists' FROM pinkpanther_stats WHERE Player = 'Adam'"; $adam_assists_results = mysql_query($adam_assists_query) or die ("Query failed ($adam_assists_query) - " . mysql_error()); $adam_assists_row = mysql_fetch_array($adam_assists_results); $adam_assists = $adam_assists_row['adam_assists']; $adam_ck_query = "SELECT SUM(CK) AS 'adam_ck' FROM pinkpanther_stats WHERE Player = 'Adam'"; $adam_ck_results = mysql_query($adam_ck_query) or die ("Query failed ($adam_ck_query) - " . mysql_error()); $adam_ck_row = mysql_fetch_array($adam_ck_results); $adam_ck = $adam_ck_row['adam_ck']; $adam_yc_query = "SELECT SUM(YC) AS 'adam_yc' FROM pinkpanther_stats WHERE Player = 'Adam'"; $adam_yc_results = mysql_query($adam_yc_query) or die ("Query failed ($adam_yc_query) - " . mysql_error()); $adam_yc_row = mysql_fetch_array($adam_yc_results); $adam_yc = $adam_yc_row['adam_yc']; $adam_rc_query = "SELECT SUM(RC) AS 'adam_rc' FROM pinkpanther_stats WHERE Player = 'Adam'"; $adam_rc_results = mysql_query($adam_rc_query) or die ("Query failed ($adam_rc_query) - " . mysql_error()); $adam_rc_row = mysql_fetch_array($adam_rc_results); $adam_rc = $adam_rc_row['adam_rc']; $adam_goalie = ""; }else{ $adam_stats_query = "SELECT * FROM pinkpanther_stats WHERE Player = 'Adam' AND Day_Played = '$adam_view'"; $adam_stats_results = mysql_query($adam_stats_query) or die ("Query failed ($adam_stats_query) - " . mysql_error()); $adam_stats_row = mysql_fetch_array($adam_stats_results); $adam_goalie_test = $adam_stats_row['Goalie']; $adam_gli = $adam_stats_row['GLI']; $adam_goals = $adam_stats_row['Goals']; $adam_saves = $adam_stats_row['Saves']; $adam_sog = $adam_stats_row['SOG']; $adam_assists = $adam_stats_row['Assists']; $adam_ck = $adam_stats_row['CK']; $adam_yc = $adam_stats_row['YC']; $adam_rc = $adam_stats_row['RC']; if ($adam_goalie_test == 1){ $adam_goalie = "Yes"; }else{ $adam_goalie = "No"; } } } ?>

I followed this tutorial http://www.nawrik.com/programming/php/create-a-php-array-from-a-csv-file/ and it all works now

I did a test and found that my code works when my csv only has 1 set of data like this Number;Name;Half;Goals;Assists;SOGs;Shots;Fouls;Yellow Cards;Yellow/Red Cards;Red Cards;CKs;Saves But when my csv looks like this Number;Name;Half;Goals;Assists;SOGs;Shots;Fouls;Yellow Cards;Yellow/Red Cards;Red Cards;CKs;Saves; Anthony;Anthony;1;0;0;0;0;0;0;0;0;0;0; Anthony;Anthony;2;0;0;0;0;0;0;0;0;0;0; Time Played:: 27:31; billy;Billy;1;0;1;0;0;0;0;0;0;0;0; billy;Billy;2;0;0;0;0;0;0;0;0;0;0; Time Played:: 00:00; chandler;Chandler;1;0;0;0;2;0;0;0;0;0;0; chandler;Chandler;2;0;0;0;0;0;0;0;0;0;0; Time Played:: 27:31; dawson;Dawson;1;1;0;1;6;0;0;0;0;0;1; dawson;Dawson;2;0;0;0;0;0;0;0;0;0;0; Time Played:: 27:31; dominic;Dominic;1;4;0;4;7;0;0;0;0;0;0; dominic;Dominic;2;0;0;0;0;0;0;0;0;0;0; Time Played:: 27:31; jarod;Jarod;1;0;0;0;2;0;0;0;0;0;1; jarod;Jarod;2;0;0;0;0;0;0;0;0;0;0; Time Played:: 27:31; justin;Justin;1;0;0;0;1;0;0;0;0;0;0; justin;Justin;2;0;0;0;0;0;0;0;0;0;0; Time Played:: 27:31; mikey;Mikey;1;0;0;0;0;0;0;0;0;0;0; mikey;Mikey;2;0;0;0;0;0;0;0;0;0;0; Time Played:: 27:31; nick;Nick;1;0;0;0;1;0;0;0;0;0;0; nick;Nick;2;0;0;0;0;0;0;0;0;0;0; Time Played:: 27:31; ryan;Ryan;1;0;0;0;2;0;0;0;0;0;0; ryan;Ryan;2;0;0;0;0;0;0;0;0;0;0; Time Played:: 27:31; tj;TJ;1;0;0;0;1;0;0;0;0;0;0; tj;TJ;2;0;0;0;0;0;0;0;0;0;0; Time Played:: 27:31; tyler;Tyler;1;2;0;2;3;0;0;0;0;1;0; tyler;Tyler;2;0;0;0;0;0;0;0;0;0;0; Time Played:: 27:31; i get this error Notice: Undefined offset: 2 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 15 Notice: Undefined offset: 3 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 16 Notice: Undefined offset: 4 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 17 Notice: Undefined offset: 5 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 18 Notice: Undefined offset: 6 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 19 Notice: Undefined offset: 7 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 20 Notice: Undefined offset: 8 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 21 Notice: Undefined offset: 9 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 22 Notice: Undefined offset: 10 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 23 Notice: Undefined offset: 11 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 24 Notice: Undefined offset: 12 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 25 Notice: Undefined offset: 2 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 15 Notice: Undefined offset: 3 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 16 Notice: Undefined offset: 4 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 17 Notice: Undefined offset: 5 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 18 Notice: Undefined offset: 6 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 19 Notice: Undefined offset: 7 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 20 Notice: Undefined offset: 8 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 21 Notice: Undefined offset: 9 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 22 Notice: Undefined offset: 10 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 23 Notice: Undefined offset: 11 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 24 Notice: Undefined offset: 12 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 25 Notice: Undefined offset: 2 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 15 Notice: Undefined offset: 3 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 16 Notice: Undefined offset: 4 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 17 Notice: Undefined offset: 5 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 18 Notice: Undefined offset: 6 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 19 Notice: Undefined offset: 7 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 20 Notice: Undefined offset: 8 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 21 Notice: Undefined offset: 9 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 22 Notice: Undefined offset: 10 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 23 Notice: Undefined offset: 11 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 24 Notice: Undefined offset: 12 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 25 Notice: Undefined offset: 2 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 15 Notice: Undefined offset: 3 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 16 Notice: Undefined offset: 4 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 17 Notice: Undefined offset: 5 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 18 Notice: Undefined offset: 6 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 19 Notice: Undefined offset: 7 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 20 Notice: Undefined offset: 8 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 21 Notice: Undefined offset: 9 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 22 Notice: Undefined offset: 10 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 23 Notice: Undefined offset: 11 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 24 Notice: Undefined offset: 12 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 25 Notice: Undefined offset: 2 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 15 Notice: Undefined offset: 3 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 16 Notice: Undefined offset: 4 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 17 Notice: Undefined offset: 5 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 18 Notice: Undefined offset: 6 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 19 Notice: Undefined offset: 7 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 20 Notice: Undefined offset: 8 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 21 Notice: Undefined offset: 9 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 22 Notice: Undefined offset: 10 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 23 Notice: Undefined offset: 11 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 24 Notice: Undefined offset: 12 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 25 Notice: Undefined offset: 2 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 15 Notice: Undefined offset: 3 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 16 Notice: Undefined offset: 4 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 17 Notice: Undefined offset: 5 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 18 Notice: Undefined offset: 6 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 19 Notice: Undefined offset: 7 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 20 Notice: Undefined offset: 8 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 21 Notice: Undefined offset: 9 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 22 Notice: Undefined offset: 10 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 23 Notice: Undefined offset: 11 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 24 Notice: Undefined offset: 12 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 25 Notice: Undefined offset: 2 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 15 Notice: Undefined offset: 3 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 16 Notice: Undefined offset: 4 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 17 Notice: Undefined offset: 5 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 18 Notice: Undefined offset: 6 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 19 Notice: Undefined offset: 7 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 20 Notice: Undefined offset: 8 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 21 Notice: Undefined offset: 9 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 22 Notice: Undefined offset: 10 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 23 Notice: Undefined offset: 11 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 24 Notice: Undefined offset: 12 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 25 Notice: Undefined offset: 2 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 15 Notice: Undefined offset: 3 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 16 Notice: Undefined offset: 4 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 17 Notice: Undefined offset: 5 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 18 Notice: Undefined offset: 6 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 19 Notice: Undefined offset: 7 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 20 Notice: Undefined offset: 8 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 21 Notice: Undefined offset: 9 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 22 Notice: Undefined offset: 10 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 23 Notice: Undefined offset: 11 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 24 Notice: Undefined offset: 12 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 25 Notice: Undefined offset: 2 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 15 Notice: Undefined offset: 3 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 16 Notice: Undefined offset: 4 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 17 Notice: Undefined offset: 5 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 18 Notice: Undefined offset: 6 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 19 Notice: Undefined offset: 7 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 20 Notice: Undefined offset: 8 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 21 Notice: Undefined offset: 9 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 22 Notice: Undefined offset: 10 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 23 Notice: Undefined offset: 11 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 24 Notice: Undefined offset: 12 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 25 Notice: Undefined offset: 2 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 15 Notice: Undefined offset: 3 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 16 Notice: Undefined offset: 4 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 17 Notice: Undefined offset: 5 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 18 Notice: Undefined offset: 6 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 19 Notice: Undefined offset: 7 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 20 Notice: Undefined offset: 8 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 21 Notice: Undefined offset: 9 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 22 Notice: Undefined offset: 10 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 23 Notice: Undefined offset: 11 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 24 Notice: Undefined offset: 12 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 25 Notice: Undefined offset: 2 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 15 Notice: Undefined offset: 3 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 16 Notice: Undefined offset: 4 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 17 Notice: Undefined offset: 5 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 18 Notice: Undefined offset: 6 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 19 Notice: Undefined offset: 7 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 20 Notice: Undefined offset: 8 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 21 Notice: Undefined offset: 9 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 22 Notice: Undefined offset: 10 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 23 Notice: Undefined offset: 11 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 24 Notice: Undefined offset: 12 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 25 Notice: Undefined offset: 2 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 15 Notice: Undefined offset: 3 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 16 Notice: Undefined offset: 4 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 17 Notice: Undefined offset: 5 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 18 Notice: Undefined offset: 6 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 19 Notice: Undefined offset: 7 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 20 Notice: Undefined offset: 8 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 21 Notice: Undefined offset: 9 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 22 Notice: Undefined offset: 10 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 23 Notice: Undefined offset: 11 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 24 Notice: Undefined offset: 12 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 25 Notice: Undefined offset: 1 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 14 Notice: Undefined offset: 2 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 15 Notice: Undefined offset: 3 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 16 Notice: Undefined offset: 4 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 17 Notice: Undefined offset: 5 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 18 Notice: Undefined offset: 6 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 19 Notice: Undefined offset: 7 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 20 Notice: Undefined offset: 8 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 21 Notice: Undefined offset: 9 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 22 Notice: Undefined offset: 10 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 23 Notice: Undefined offset: 11 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 24 Notice: Undefined offset: 12 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 25 Notice: Undefined offset: 1 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 14 Notice: Undefined offset: 2 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 15 Notice: Undefined offset: 3 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 16 Notice: Undefined offset: 4 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 17 Notice: Undefined offset: 5 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 18 Notice: Undefined offset: 6 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 19 Notice: Undefined offset: 7 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 20 Notice: Undefined offset: 8 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 21 Notice: Undefined offset: 9 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 22 Notice: Undefined offset: 10 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 23 Notice: Undefined offset: 11 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 24 Notice: Undefined offset: 12 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 25 Notice: Undefined offset: 1 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 14 Notice: Undefined offset: 2 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 15 Notice: Undefined offset: 3 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 16 Notice: Undefined offset: 4 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 17 Notice: Undefined offset: 5 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 18 Notice: Undefined offset: 6 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 19 Notice: Undefined offset: 7 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 20 Notice: Undefined offset: 8 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 21 Notice: Undefined offset: 9 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 22 Notice: Undefined offset: 10 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 23 Notice: Undefined offset: 11 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 24 Notice: Undefined offset: 12 in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 25

ya ha that was the first thing i checked when i just tell it to show the .csv info with this code $file = fopen("playerstats.csv","r"); while(! feof($file)) { print_r(fgetcsv($file, 0, ";")); echo "<br />"; } this is what it shows Array ( [0] => Number [1] => Name [2] => Half [3] => Goals [4] => Assists [5] => SOGs [6] => Shots [7] => Fouls [8] => Yellow Cards [9] => Yellow/Red Cards [10] => Red Cards [11] => CKs [12] => Saves [13] => ) Array ( [0] => Anthony [1] => Anthony [2] => 1 [3] => 0 [4] => 0 [5] => 0 [6] => 0 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => Anthony [1] => Anthony [2] => 2 [3] => 0 [4] => 0 [5] => 0 [6] => 0 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => Time Played:: 27:31 [1] => ) Array ( [0] => billy [1] => Billy [2] => 1 [3] => 0 [4] => 1 [5] => 0 [6] => 0 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => billy [1] => Billy [2] => 2 [3] => 0 [4] => 0 [5] => 0 [6] => 0 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => Time Played:: 00:00 [1] => ) Array ( [0] => chandler [1] => Chandler [2] => 1 [3] => 0 [4] => 0 [5] => 0 [6] => 2 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => chandler [1] => Chandler [2] => 2 [3] => 0 [4] => 0 [5] => 0 [6] => 0 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => Time Played:: 27:31 [1] => ) Array ( [0] => dawson [1] => Dawson [2] => 1 [3] => 1 [4] => 0 [5] => 1 [6] => 6 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 1 [13] => ) Array ( [0] => dawson [1] => Dawson [2] => 2 [3] => 0 [4] => 0 [5] => 0 [6] => 0 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => Time Played:: 27:31 [1] => ) Array ( [0] => dominic [1] => Dominic [2] => 1 [3] => 4 [4] => 0 [5] => 4 [6] => 7 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => dominic [1] => Dominic [2] => 2 [3] => 0 [4] => 0 [5] => 0 [6] => 0 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => Time Played:: 27:31 [1] => ) Array ( [0] => jarod [1] => Jarod [2] => 1 [3] => 0 [4] => 0 [5] => 0 [6] => 2 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 1 [13] => ) Array ( [0] => jarod [1] => Jarod [2] => 2 [3] => 0 [4] => 0 [5] => 0 [6] => 0 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => Time Played:: 27:31 [1] => ) Array ( [0] => justin [1] => Justin [2] => 1 [3] => 0 [4] => 0 [5] => 0 [6] => 1 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => justin [1] => Justin [2] => 2 [3] => 0 [4] => 0 [5] => 0 [6] => 0 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => Time Played:: 27:31 [1] => ) Array ( [0] => mikey [1] => Mikey [2] => 1 [3] => 0 [4] => 0 [5] => 0 [6] => 0 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => mikey [1] => Mikey [2] => 2 [3] => 0 [4] => 0 [5] => 0 [6] => 0 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => Time Played:: 27:31 [1] => ) Array ( [0] => nick [1] => Nick [2] => 1 [3] => 0 [4] => 0 [5] => 0 [6] => 1 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => nick [1] => Nick [2] => 2 [3] => 0 [4] => 0 [5] => 0 [6] => 0 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => Time Played:: 27:31 [1] => ) Array ( [0] => ryan [1] => Ryan [2] => 1 [3] => 0 [4] => 0 [5] => 0 [6] => 2 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => ryan [1] => Ryan [2] => 2 [3] => 0 [4] => 0 [5] => 0 [6] => 0 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => Time Played:: 27:31 [1] => ) Array ( [0] => tj [1] => TJ [2] => 1 [3] => 0 [4] => 0 [5] => 0 [6] => 1 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => tj [1] => TJ [2] => 2 [3] => 0 [4] => 0 [5] => 0 [6] => 0 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => Time Played:: 27:31 [1] => ) Array ( [0] => tyler [1] => Tyler [2] => 1 [3] => 2 [4] => 0 [5] => 2 [6] => 3 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 1 [12] => 0 [13] => ) Array ( [0] => tyler [1] => Tyler [2] => 2 [3] => 0 [4] => 0 [5] => 0 [6] => 0 [7] => 0 [8] => 0 [9] => 0 [10] => 0 [11] => 0 [12] => 0 [13] => ) Array ( [0] => Time Played:: 27:31 [1] => ) Array ( [0] => ) Array ( [0] => ) Array ( [0] => )

when i do the <?php echo $number;?> i get this error Notice: Undefined variable: number in C:\xampp\htdocs\PhotosByChristian\Untitled-1.php on line 55