question

msnhockey

I have a stats website and what i am trying to do is put a little injured image beside a player when he is injured.

The table name is players, the column name is Injured. The options below are what can only be entered into that column..

my database when inputting into the DB has 5 options.
Rookie , Injured , Healthy , Retired or Minors

The DB is a Text field.

So basically on my stats page when this word Injured shows up against a player. the word Injured somehow needs to be transforrmed into an injury pic (injury.gif)

how do I go about adding this option in. everytime I try its all or nothing...

thansk

msnhockey

here is the code for calling to db

//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);

msnhockey

Hi all,

I have been playing around with this and still no luck.... here is what I have came up with so far. If I put the $image by itself the image shows up
but when I try to take Injured out of the status section in the db nothing shows

The DB name is players, the column name is status and the wording in status is Injured.

I am trying to make it so if a players status comes up Injured then a injured image shows up besides his name

$stats_sql9 = "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.status = 'Injured'";

$stats_sql7 = mysql_query("$stats_sql9");

$stats_sql6 = mysql_result($stats_sql7,0,"status");
$stats_sql8 = mysql_result($stats_sql7,0,"status");
if ($stats_sql9 != Rookie) {
$nosite = $image;
} else {
$nosite = $image;
}

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