[RESOLVED] coding problem.. please help

[msnhockey]

Here is my problem.....

my database is called UFHL
the table I want to access is players
the column/row I want info from is status

that row/column has 5 options in it Injured , Rookie , Healthy , Minors or Retired

all that is fine

what I am trying to do is when a players status is at Injured on my stats screen I want a injury image to show up. Right now I get get an image to show for all players or nothing at all and the same with the text out of the DB

does anyone have any ideas on where I should start. I have been trying for like 3 hrs plus now and am no further ahead than I was.

here is the code below that is used to call the players name and stats from various tables

PLEASE HELP ME I'M DESPERATE

thanks everyone

$stats_sql = "SELECT * FROM player_stats,teams,players WHERE player_stats.seasonid = '".$sid."' AND "
."teams.id = player_stats.team_id AND "
."players.id = player_stats.playerid AND players.position != 'G'";

$result_stats = mysql_query("$stats_sql");
if(!$result_stats) { echo mysql_errno().": ".mysql_error()."<br>"; }
$statcount = mysql_numrows($result_stats);

here is the code I have been playing with

$injured = "SELECT * FROM players WHERE status = 'Injured'";
$stats_sql7 = mysql_query("$injured");
$stats_sql8 = mysql_result($stats_sql7,0,"status");

if(mysql_result($stats_sql8,0,"status") != "Injured")  { 
$nosite =  " "; 
} else { 
$nosite = "$image"; 

[laserlight]

Do you want to:
a. display the status of a single player, and if that player status is "injured", display an "injured" image, or
b. list all the players, displaying an "injured" image for all those whose status is "injured", or
c. list all players whose status is "injured"?

[msnhockey]

here is my page with which i am working with
http://theufhl.com/?opt=leaguelead&sid=000000000004

your
b. list all the players, displaying an "injured" image for all those whose status is "injured",

this is what i am trying to do..

thanks

[laserlight]

Ah, then it is quite simple. Just select all the columns you need, including the status column (duh). When you loop over the result set, check if the status of the current player is "injured". If so, print the image.

[msnhockey]

any suggestions how.... i've tried almost everything i think

i'm pretty new to php. the script I have was purchased and I'm trying to mod to fit my needs

thanks

[laserlight]

Basically, you are looking to write something like this:

while ($row = mysql_fetch_assoc($result_stats))
{
    // print stuff

if ($row['status'] == 'Injured')
{
    // print image
}

// print more stuff
}

[msnhockey]

I have inserted the code where the red text is. all that comes up is ARRAY

any ideas anyone on where I should place this code or change something.

I am desperate...please help

thanks

<?php


//HOMEPAGE
function divstats($sid) {

 include("config.php");

//LOAD THE HTML
$filename = $sport_dir."html/zleaguestatsbody1.html";
$fd = fopen ($filename, "r");
$contents = fread ($fd, filesize ($filename));
fclose ($fd);

    $open = mysql_connect($hostname,$user,$password);
    mysql_select_db("$db",$open);


//LEAGUE TITLE
    $result_leagueinfo = mysql_query("SELECT * FROM leagueinfo");
$rcount = mysql_numrows($result_leagueinfo);
    if($rcount != 0) {
            $league_name = mysql_result($result_leagueinfo,0,"name");
    } else {
	$league_name = "Your Hockey League";
}

//GET CURRENT SEASON
$result_season = mysql_query("SELECT name FROM seasons WHERE id = '".$sid."'");
$seasonname = mysql_result($result_season,0,"name");

	//GET CURRENT DIVISION
//		$result_division2 = mysql_query("SELECT name FROM divisions WHERE id = '".$divid."'");
//		$divisionname2 = mysql_result($result_division2,0,"name");








//get player stats

$stats_sql = "SELECT * FROM player_stats,teams,players WHERE player_stats.seasonid = '".$sid."' AND "
."teams.id = player_stats.team_id AND "
."players.id = player_stats.playerid AND players.position != 'G'";












			$result_stats = mysql_query("$stats_sql");
			if(!$result_stats) { echo mysql_errno().": ".mysql_error()."<br>"; }
			$statcount = mysql_numrows($result_stats);









[COLOR="Red"]while ($row = mysql_fetch_assoc($result_stats)) 
{ [/COLOR]



//start point stats

            $sc = 0;
			$p_array = Array();
			while($sc < $statcount) {
			$playerid = mysql_result($result_stats,$sc,"players.id");
		        $p_array[$playerid][goals] = $p_array[$playerid][goals] + mysql_result($result_stats,$sc,"player_stats.goals");
		        $p_array[$playerid][assists] = $p_array[$playerid][assists] + mysql_result($result_stats,$sc,"player_stats.assists");
		        $p_array[$playerid][pts] = $p_array[$playerid][pts] + mysql_result($result_stats,$sc,"player_stats.goals") + mysql_result($result_stats,$sc,"player_stats.assists");
		        $p_array[$playerid][minutes] = $p_array[$playerid][minutes] + mysql_result($result_stats,$sc,"player_stats.minutes");
		        $p_array[$playerid][xtra1] = $p_array[$playerid][xtra1] + mysql_result($result_stats,$sc,"player_stats.xtra1");
		        $p_array[$playerid][xtra2] = $p_array[$playerid][xtra2] + mysql_result($result_stats,$sc,"player_stats.xtra2");
		        $p_array[$playerid][xtra3] = $p_array[$playerid][xtra3] + mysql_result($result_stats,$sc,"player_stats.xtra3");
		        $p_array[$playerid][xtra4] = $p_array[$playerid][xtra4] + mysql_result($result_stats,$sc,"player_stats.xtra4");
		        $p_array[$playerid][shoot] = ROUND($p_array[$playerid][goals] / $p_array[$playerid][xtra4] * 100, 2);                                
                            $p_array[$playerid][position] = mysql_result($result_stats,$sc,"players.position");
$p_array[$playerid][fname] = mysql_result($result_stats,$sc,"players.fname");
			        $p_array[$playerid][lname] = mysql_result($result_stats,$sc,"players.lname");
$p_array[$playerid][status] = mysql_result($result_stats,$sc,"players.status");
 [COLOR="Red"]       if ($row[status] == 'Injured') 
    { 
        $image = "<img border=\"0\" src=\"http://www.theufhl.com/images/injury.gif\">";
    }  [/color]

			$p_array[$playerid][team] = mysql_result($result_stats,$sc,"teams.name");
			//Added next 3 lines for showing links for players and teams 10-14-05 DJ
			$p_array[$playerid][tid] = mysql_result($result_stats,$sc,"teams.id");
			$p_array[$playerid][divid] = mysql_result($result_stats,$sc,"teams.division");
			$p_array[$playerid][pid] = mysql_result($result_stats,$sc,"players.id");$sc++;
			}




		        uasort($p_array, 'Compare_stats');


           for($i=0; $i<50; $i++)
		   {
            list ($key, $value) = each ($p_array);



$ppnum = ($i + 1);




  //ROW COLOR
		                $tbgcolor = is_int($i / 2)?"#efefef":"#ffffff";

		                $p_stats .= "
		                <tr bgcolor=\"".$tbgcolor."\" align=\"center\">
<td class=\"table_text\">$ppnum</td>
			                <td class=\"table_text\"><a href=\"./?opt=viewplayer&pid=".$value["pid"]."&sid=".$sid."&tid=".$value["tid"]."&divid=".$value["divid"]."\">"
			                .$value["fname"]." ".$value["lname"]."  </a>
  $row

</td>
			                <td class=\"table_text\"><a href=\"./?opt=viewteam&id=".$value["tid"]."&sid=".$sid."&divid=".$value["divid"]."\">".$value["team"]."</a></td>

<td class=\"table_text\">".$value["position"]."</td> 

<td class=\"table_text\">".$value["goals"]."</td> 
                                        <td class=\"table_text\">".$value["assists"]."</td>       

                                        <td class=\"table_text\" bgcolor=\"#999999\">".$value["pts"]."</td>
			                <td class=\"table_text\">".$value["minutes"]."</td>
			                <td class=\"table_text\">".$value["xtra1"]."</td>
			                <td class=\"table_text\">".$value["xtra2"]."</td>
			                <td class=\"table_text\">".$value["xtra3"]."</td>
			                <td class=\"table_text\">".$value["xtra4"]."</td>
			                <td class=\"table_text\">".$value["shoot"]."</td>
                                        </tr>";
			     }

		        if($i == 0) {
		                $p_stats .= "<tr><td class=\"body_text\" align=\"center\" colspan=\"3\"
		                        bgcolor=\"#efefef\"><!--%cc_nostats%--></td></tr>";
		        }

//end point stats



  [COLOR="Red"]   } [/color]


$body_body = $stats;



return $contents;

}

?>

[msnhockey]

i am having lots of problems getting this to show. I just re-edited my code above..

the code in red is what I am working with to show the image. All that shows up is ARRAY..

Any help or suggestions is appriciated

thanks

[Roger_Ramjet]

Maybe I'm blind, but I can't see where you use $image once you've set it???

[msnhockey]

  //ROW COLOR
$tbgcolor = is_int($i / 2)?"#efefef":"#ffffff";

$p_stats .= "
<tr bgcolor=\"".$tbgcolor."\" align=\"center\">
<td class=\"table_text\">$ppnum</td>
<td class=\"table_text\"><a href=\"./?opt=viewplayer&pid=".$value["pid"]."&sid=".$sid."&tid=".$value["tid"]."&divid=".$value["divid"]."\">"
 .$value["fname"]." ".$value["lname"]."  </a>
 [COLOR="Red"]$image[/COLOR] 

it shows as $row in the code above.. i have been playing around with it alot

[Roger_Ramjet]

Well your first problem is that you are not quoting the array key - look at Laserlight's code for the correct syntax.

[msnhockey]

even if I do it laserlights way I still get nothing showing up

[Roger_Ramjet]

OK

1. Where is the actual page with the problem

2. You have to start by using the right syntax, ie

   if ($row['status'] == 'Injured')
   

   or nothing can be fixed

[msnhockey]

i have that line entered and nothing..

I seen what you said before without the ' ' beside the word status

[Roger_Ramjet]

so gimme the URL so I can see the problem and post the code THAT IS BEING USED RIGHT NOW to produce the problem

[msnhockey]

here is the url
http://theufhl.com/?opt=leaguelead&sid=000000000004

<?php



//HOMEPAGE
function divstats($sid) {

 include("config.php");

//LOAD THE HTML
$filename = $sport_dir."html/zleaguestatsbody1.html";
$fd = fopen ($filename, "r");
$contents = fread ($fd, filesize ($filename));
fclose ($fd);

    $open = mysql_connect($hostname,$user,$password);
    mysql_select_db("$db",$open);


//LEAGUE TITLE
    $result_leagueinfo = mysql_query("SELECT * FROM leagueinfo");
$rcount = mysql_numrows($result_leagueinfo);
    if($rcount != 0) {
            $league_name = mysql_result($result_leagueinfo,0,"name");
    } else {
	$league_name = "Your Hockey League";
}

//GET CURRENT SEASON
$result_season = mysql_query("SELECT name FROM seasons WHERE id = '".$sid."'");
$seasonname = mysql_result($result_season,0,"name");

	//GET CURRENT DIVISION
//		$result_division2 = mysql_query("SELECT name FROM divisions WHERE id = '".$divid."'");
//		$divisionname2 = mysql_result($result_division2,0,"name");








//get player stats

$stats_sql = "SELECT * FROM player_stats,teams,players WHERE player_stats.seasonid = '".$sid."' AND "
."teams.id = player_stats.team_id AND "
."players.id = player_stats.playerid AND players.position != 'G'";












			$result_stats = mysql_query("$stats_sql");
			if(!$result_stats) { echo mysql_errno().": ".mysql_error()."<br>"; }
			$statcount = mysql_numrows($result_stats);


[COLOR="Red"]
 while ($row = mysql_fetch_assoc($result_stats)) 
{ 

[/COLOR]










//start point stats

            $sc = 0;
			$p_array = Array();
			while($sc < $statcount) {
			$playerid = mysql_result($result_stats,$sc,"players.id");
		        $p_array[$playerid][goals] = $p_array[$playerid][goals] + mysql_result($result_stats,$sc,"player_stats.goals");
		        $p_array[$playerid][assists] = $p_array[$playerid][assists] + mysql_result($result_stats,$sc,"player_stats.assists");
		        $p_array[$playerid][pts] = $p_array[$playerid][pts] + mysql_result($result_stats,$sc,"player_stats.goals") + mysql_result($result_stats,$sc,"player_stats.assists");
		        $p_array[$playerid][minutes] = $p_array[$playerid][minutes] + mysql_result($result_stats,$sc,"player_stats.minutes");
		        $p_array[$playerid][xtra1] = $p_array[$playerid][xtra1] + mysql_result($result_stats,$sc,"player_stats.xtra1");
		        $p_array[$playerid][xtra2] = $p_array[$playerid][xtra2] + mysql_result($result_stats,$sc,"player_stats.xtra2");
		        $p_array[$playerid][xtra3] = $p_array[$playerid][xtra3] + mysql_result($result_stats,$sc,"player_stats.xtra3");
		        $p_array[$playerid][xtra4] = $p_array[$playerid][xtra4] + mysql_result($result_stats,$sc,"player_stats.xtra4");
		        $p_array[$playerid][shoot] = ROUND($p_array[$playerid][goals] / $p_array[$playerid][xtra4] * 100, 2);                                
                            $p_array[$playerid][position] = mysql_result($result_stats,$sc,"players.position");
$p_array[$playerid][fname] = mysql_result($result_stats,$sc,"players.fname");
			        $p_array[$playerid][lname] = mysql_result($result_stats,$sc,"players.lname");
$p_array[$playerid][status] = mysql_result($result_stats,$sc,"players.status");
[COLOR="Red"]  $row["status"];
      if ($row['status'] == 'Injured') 
    {   

       $image1 = $image = "<img border=\"0\" src=\"http://www.theufhl.com/images/injury.gif\">";
    } 
[/COLOR]


			$p_array[$playerid][team] = mysql_result($result_stats,$sc,"teams.name");
			//Added next 3 lines for showing links for players and teams 10-14-05 DJ
			$p_array[$playerid][tid] = mysql_result($result_stats,$sc,"teams.id");
			$p_array[$playerid][divid] = mysql_result($result_stats,$sc,"teams.division");
			$p_array[$playerid][pid] = mysql_result($result_stats,$sc,"players.id");$sc++;
			}




		        uasort($p_array, 'Compare_stats');



           for($i=0; $i<50; $i++)
		   {
            list ($key, $value) = each ($p_array);



$ppnum = ($i + 1);




  //ROW COLOR
		                $tbgcolor = is_int($i / 2)?"#efefef":"#ffffff";

		                $p_stats .= "
		                <tr bgcolor=\"".$tbgcolor."\" align=\"center\">
<td class=\"table_text\">$ppnum</td>
			                <td class=\"table_text\"><a href=\"./?opt=viewplayer&pid=".$value["pid"]."&sid=".$sid."&tid=".$value["tid"]."&divid=".$value["divid"]."\">"
			                .$value["fname"]." ".$value["lname"]."  </a>
 [COLOR="Red"] $image1[/color]

</td>
			                <td class=\"table_text\"><a href=\"./?opt=viewteam&id=".$value["tid"]."&sid=".$sid."&divid=".$value["divid"]."\">".$value["team"]."</a></td>

<td class=\"table_text\">".$value["position"]."</td> 

<td class=\"table_text\">".$value["goals"]."</td> 
                                        <td class=\"table_text\">".$value["assists"]."</td>       

                                        <td class=\"table_text\" bgcolor=\"#999999\">".$value["pts"]."</td>
			                <td class=\"table_text\">".$value["minutes"]."</td>
			                <td class=\"table_text\">".$value["xtra1"]."</td>
			                <td class=\"table_text\">".$value["xtra2"]."</td>
			                <td class=\"table_text\">".$value["xtra3"]."</td>
			                <td class=\"table_text\">".$value["xtra4"]."</td>
			                <td class=\"table_text\">".$value["shoot"]."</td>
                                        </tr>";
			     }



		        if($i == 0) {
		                $p_stats .= "<tr><td class=\"body_text\" align=\"center\" colspan=\"3\"
		                        bgcolor=\"#efefef\"><!--%cc_nostats%--></td></tr>";
		        }

//end point stats



   [COLOR="Red"]  }  [/COLOR]


$body_body = $stats;

	return $contents;

}

?>

[Roger_Ramjet]

Oh yeah! And where is this 'player status' where the image is supposed to go then?

[msnhockey]

hey,

the image needs to show next to the players name

			                $tbgcolor = is_int($i / 2)?"#efefef":"#ffffff";

		                $p_stats .= "
		                <tr bgcolor=\"".$tbgcolor."\" align=\"center\">
<td class=\"table_text\">$ppnum</td>
			                <td class=\"table_text\"><a href=\"./?opt=viewplayer&pid=".$value["pid"]."&sid=".$sid."&tid=".$value["tid"]."&divid=".$value["divid"]."\">"
			                .$value["fname"]." ".$value["lname"]."  </a>
  $image1

[bpat1434]

Perhaps I'm the blind one 😉 I can't seem to find $stats defined in the function before it's used, and I can't seem to figure out where $body_body comes into play, or how $p_stats gets put into the template......

But I cleaned up your code, and hopefully made it easier for you. Don't just copy and paste this. Make sure you examine it and understand what it's doing. I changed the query quite a bit, but it should work.

<?php
//HOMEPAGE
function divstats($sid) {
	include("config.php");

$filename = $sport_dir."html/zleaguestatsbody1.html";
$fd = fopen ($filename, "r");
$contents = fread ($fd, filesize ($filename));
fclose ($fd);

$open = mysql_connect($hostname,$user,$password);
mysql_select_db("$db",$open);

//LEAGUE TITLE
$result_leagueinfo = mysql_query("SELECT * FROM leagueinfo");
$rcount = mysql_numrows($result_leagueinfo);
if($rcount != 0) {
	$league_name = mysql_result($result_leagueinfo,0,"name");
} else {
	$league_name = "Your Hockey League";
}

//GET CURRENT SEASON
$result_season = mysql_query("SELECT name FROM seasons WHERE id = '".$sid."'");
$seasonname = mysql_result($result_season,0,"name");

//GET CURRENT DIVISION
#	$result_division2 = mysql_query("SELECT name FROM divisions WHERE id = '".$divid."'");
#	$divisionname2 = mysql_result($result_division2,0,"name");

//get player stats
$stats_sql = "SELECT SUM(ps.goals) AS goals, SUM(ps.assists) AS assists, SUM(ps.minutes) AS minutes, SUM(ps.xtra1) AS xtra1, SUM(ps.xtra2) AS xtra2, SUM(ps.xtra3) AS xtra3, SUM(ps.xtra4) AS xtra4, p.position, p.fname, p.lname, p.status, p.status, t.name, t.division, t.tid, p.pid,
FROM player_stats ps, teams t, players p
WHERE ps.seasonid = '".$sid."' 
  AND teams.id = ps.team_id 
  AND p.id = ps.playerid 
  AND p.position != 'G'
GROUP BY p.id";

$result_stats = mysql_query($stats_sql);
if(!$result_stats) { echo mysql_errno().": ".mysql_error()."<br>"; }
$statcount = mysql_num_rows($result_stats);

while ($row = mysql_fetch_assoc($result_stats)) 
{ 
	//start point stats
	$p_array = Array();
	$playerid = $row['pid'];

	$p_array[$playerid]['goals'] = $row['goals'];
	$p_array[$playerid]['assists'] = $row['assists'];
	$p_array[$playerid]['pts'] = $row['goals']+$row['assits'];
	$p_array[$playerid]['minutes'] = $row['minutes'];
	$p_array[$playerid]['xtra1'] = $row['xtra1'];
	$p_array[$playerid]['xtra2'] = $row['xtra2'];
	$p_array[$playerid]['xtra3'] = $row['xtra3'];
	$p_array[$playerid]['xtra4'] = $row['xtra4'];
	$p_array[$playerid]['shoot'] = ROUND($row['goals'] / $row['xtra4'] * 100, 2);                                
	$p_array[$playerid]['position'] = $row['position'];
	$p_array[$playerid]['fname'] = $row['fname'];
	$p_array[$playerid]['lname'] = $row['lname'];
	$p_array[$playerid]['status'] = $row['status'];
	$p_array[$playerid]['team'] = $row['name'];
	//Added next 3 lines for showing links for players and teams 10-14-05 DJ
	$p_array[$playerid]['tid'] = $row['tid'];
	$p_array[$playerid]['divid'] = $row['division'];
	$p_array[$playerid]['pid'] = $row['pid'];

	uasort($p_array, 'Compare_stats');

	$i=1;
	foreach($p_array as $id=>$player)
	{
		$ppnum = $i;
		$tbgcolor = ($i%2==0)?"#efefef":"#ffffff";

		$p_stats .= '
		<tr bgcolor="'.$tbgcolor.'" align="center">
			<td class="table_text">' . $i . '</td>
			<td class="table_text"><a href="./?opt=viewplayer&pid='.$player['pid'].'&sid='.$sid.'&tid='.$player['tid'].'&divid='.$player['divid'].'">'.$player['fname'].' '.$player['lname'].'</a>'.$row;

		if($player['status'] == 'Injured')
		{
			$p_stats .= '<img src="border="0" src="http://www.theufhl.com/images/injury.gif" />';
		}

		$p_stats .= '
			</td>
			<td class="table_text"><a href="./?opt=viewteam&id='.$player['tid'].'&sid='.$sid.'&divid='.$player['divid'].'">'.$player['team'].'</a></td>
			<td class="table_text">'.$player['position'].'</td> 
			<td class="table_text">'.$player['goals'].'</td> 
			<td class="table_text">'.$player['assists'].'</td>       
			<td class="table_text" bgcolor="#999999">'.$player['pts'].'</td>
			<td class="table_text">'.$player['minutes'].'</td>
			<td class="table_text">'.$player['xtra1'].'</td>
			<td class="table_text">'.$player['xtra2'].'</td>
			<td class="table_text">'.$player['xtra3'].'</td>
			<td class="table_text">'.$player['xtra4'].'</td>
			<td class="table_text">'.$player['shoot'].'</td>
		</tr>';
	}
	if($i == 0) {
		$p_stats .= "<tr><td class=\"body_text\" align=\"center\" colspan=\"3\"
			bgcolor=\"#efefef\"><!--%cc_nostats%--></td></tr>";
	}  
	//end point stats
}

$body_body = $stats;
return $contents;
}

?>

Edit: Forgot about the image....
Edit2: Missed a few "$row[...]" items

[msnhockey]

bpat1434

i left this out at the bottom of the code..as i didn't want to make this code to long

this is how everything is entered into the template

$body_body = $stats;

$contents = eregi_replace("<!--%ANNOUNCEMENTS%-->",$ann,$contents);
$contents = eregi_replace("<!--%LEAGUE_TITLE%-->",$league_name,$contents);
$contents = eregi_replace("<!--%TEAMPIC%-->",$body_pic,$contents);
    $contents = eregi_replace("<!--%TEAM_NAME%-->",$body_title,$contents);
$contents = eregi_replace("<!--%INFO%-->",$body_body,$contents);
    $contents = eregi_replace("<!--%MENU%-->",$menu,$contents);
$contents = eregi_replace("<!--%STATS_POINTS%-->",$p_stats,$contents);
$contents = eregi_replace("<!--%STATS_GOALS%-->",$g_stats,$contents);
$contents = eregi_replace("<!--%STATS_ASSISTS%-->",$a_stats,$contents);
$contents = eregi_replace("<!--%STATS_PIMS%-->",$pm_stats,$contents);
$contents = eregi_replace("<!--%STATS_GAA%-->",$gaa_stats,$contents);
    $contents = eregi_replace("<!--%STATS_SAVE%-->",$sv_stats,$contents);
$contents = eregi_replace("<!--%PINFO%-->",$pinfo,$contents);
$contents = eregi_replace("<!--%DIVBAR%-->",$divid,$contents);
    $contents = eregi_replace("<!--%TID%-->",$id,$contents);
$contents = eregi_replace("<!--%DIVNAMER%-->",$divisionname2,$contents);
$contents = eregi_replace("<!--%SEASONBAR%-->",$sid,$contents);

return $contents;

}

?>