Hi There,
I have a php query that pulls data from one type of hockey player and I want it to recognize different positions to pull a different query set.
Right now it looks like this
[php] $iPlayerID = $_GET[“PlayerID”];
$iNationID = $_GET[“NationID”];
$oPlayerInfo = mysql_query("
SELECT Players.PlayerID, Players.FirstName, Players.LastName, Players.Position, Players.Height, Players.Weight, Players.DOB, CNGHLTeams.CNGHLRights, NHLTeams.Team, Players.CNDraftYR, DraftTeam.DraftID, Players.CNDraftPOS, Countries.Nation, Players.NationID, DraftTeam.DrTeam, Players.FullName
FROM Players
Left JOIN CNGHLTeams
ON Players.CNGHLID=CNGHLTeams.CNGHLID
Left JOIN NHLTeams
ON Players.TeamsID=NHLTeams.TeamID
Left JOIN Countries
ON Players.NationID=Countries.NationID
Left JOIN DraftTeam
ON Players.DraftID=DraftTeam.DraftID
WHERE Players.PlayerID=$iPlayerID
ORDER BY Players.LastName;
") or die(mysql_error());
$row = mysql_fetch_array($oPlayerInfo);
?>
img.top {vertical-align:text-top;}
img.bottom {vertical-align:text-bottom;}
a {text-decoration:none;}
| "; ECHO " | "; ECHO " | "; ECHO " |
"; Print "
".$row['FirstName']." ".$row['LastName']." | ";
Print "||
| Birthdate: ".$row['DOB']." | "; $DOB = $row[DOB]; //dd.mm.yyyy $user_date = new DateTime($DOB); $curr_date = new DateTime(); $age_cal = $curr_date->diff($user_date); Print "Age: ".$age_cal->y;" | "; Print "|
| Nation: ".$row['Nation']." | "; Print "CNGHL Team: ".$row['CNGHLRights']. " | "; Print "|
| Position: ".$row['Position']. " | "; Print "Weight: ".$row['Weight']. " | "; Print "|
| Height: ".$row['Height']. " | "; Print "NHL Team: ".$row['Team']. " | "; Print "|
| Draft Year: ".$row['CNDraftYR']." | "; Print "Draft Position: ".$row['CNDraftPOS']." | "; Print "|
| Drafted By: ".$row['DrTeam']." | "; Print ""; Print " | |
';
Print "Season | ";
ECHO "Team | ";
ECHO "GP | ";
ECHO "G | ";
ECHO "A | ";
ECHO "P | ";
ECHO "PIM | ";
ECHO "+/- | ";
ECHO "PPG | ";
ECHO "SHG | ";
ECHO "GWG | ";
ECHO "GTG | ";
ECHO "Shots | ";
ECHO "
| ".$row['Sea']." | "; Print "".$row['Team']." | "; Print "".$row['GP']." | "; Print "".$row['Goals']." | "; Print "".$row['Assists']." | "; Print "".$row['Points']." | "; Print "".$row['Pim']." | "; Print "".$row['PlusMinus']." | "; Print "".$row['PP']." | "; Print "".$row['SH']." | "; Print "".$row['GW']." | "; Print "".$row['GT']." | "; Print "".$row['S']." | "; } Print "
';
Print "Season | ";
ECHO "
Team";
ECHO " | ";
ECHO "
GP";
ECHO " | ";
ECHO "
Min";
ECHO " | ";
ECHO "
GAA";
ECHO " | ";
ECHO "
W";
ECHO " | ";
ECHO "
L";
ECHO " | ";
ECHO "
OTL";
ECHO " | ";
ECHO "
T";
ECHO " | ";
ECHO "
SO";
ECHO " | ";
ECHO "
GA";
ECHO " | ";
ECHO "
SA";
ECHO " | ";
ECHO "
PCT";
ECHO " | ";
ECHO "
PIM";
ECHO " | ";
ECHO "
Assists";
ECHO " | ";
ECHO "
| ".$row['Sea']." | "; Print "".$row['Team']." | "; Print "".$row['GP']." | "; Print "".$row['Min']." | "; $iGAA = $row['GA'] * 60 / $row['Min']; Print "".$english_format_number = number_format($iGAA, 2)." | "; Print "".$row['W']." | "; Print "".$row['L']." | "; Print "".$row['OTL']." | "; Print "".$row['T']." | "; Print "".$row['SO']." | "; Print "".$row['GA']." | "; Print "".$row['SA']." | "; Print "".$row['PCT']." | "; Print "".$row['PIM']." | "; Print "".$row['Assists']." | "; } Print "