";
for ($i=0;$i<=$playerindex;$i++) {
$message=0;
for ($j=0;$j<=count($uniformarray);$j++) {
if ($playername[$i] == $uniformarray[$j][0]) {
$playername[$i] = str_replace("Ja ","JA ",$playername[$i]);
$playername[$i] = str_replace("Jb ","JB ",$playername[$i]);
$playername[$i] = str_replace("Jc ","JC ",$playername[$i]);
$playername[$i] = str_replace("Jr ","JR ",$playername[$i]);
$query3 = "SELECT name, fullname FROM cardtable WHERE (fullname LIKE '%(".$uniformarray[$j][1]."/%' OR fullname LIKE '%(".$uniformarray[$j][2]."/%' OR fullname LIKE '%(".$uniformarray[$j][3]."/%' OR fullname LIKE '%(".$uniformarray[$j][4]."/%') AND name = '".$playername[$i]."'";
$result3=mysql_query($query3);
while($row = mysql_fetch_array($result3)){
$counter++;
if ($counter<10) {$counterspacer=" ";} else {$counterspacer="";}
$fullname=$row['fullname'];
$fullname=str_replace(" ^","",$fullname);
$fullname=str_replace("^ ","",$fullname);
$fullname=str_replace("# T000","# T",$fullname);
$fullname=str_replace("# T00","# T-",$fullname);
$fullname=str_replace("# T0","# T",$fullname);
$fullname=str_replace("# UH000","# UH",$fullname);
$fullname=str_replace("# UH00","# UH",$fullname);
$fullname=str_replace("# UH0","# UH",$fullname);
$fullname=str_replace("# US-000","# US-",$fullname);
$fullname=str_replace("# US-00","# US-",$fullname);
$fullname=str_replace("# US-0","# US-",$fullname);
$fullname=str_replace("# 000","# ",$fullname);
$fullname=str_replace("# 00","# ",$fullname);
$fullname=str_replace("# 0","# ",$fullname);
$fullname=str_replace("- 000","- ",$fullname);
$fullname=str_replace("- 00","- ",$fullname);
$fullname=str_replace("- 0","- ",$fullname);
$fullname=str_replace("[ Jsy ]","",$fullname);
$fullname=str_replace("[ Jersey ]","",$fullname);
$fullname=str_replace(") Jersey",")",$fullname);
$fullname=str_replace(") Bat",")",$fullname);
$fullname=str_replace(") Auto",")",$fullname);
$fullname=str_replace("[ Uniform ]","",$fullname);
if ($message==0) {
echo "| ".$playername[$i]." wore # ".$uniformarray[$j][1];
if ($uniformarray[$j][2] != "") {echo " and # ".$uniformarray[$j][2];}
if ($uniformarray[$j][3] != "") {echo " and # ".$uniformarray[$j][3];}
if ($uniformarray[$j][4] != "") {echo " and # ".$uniformarray[$j][4];}
echo " while with the Astros: | ";
$message=1;}
echo " | ".$counterspacer.$counter.". ".$fullname." |
"; }}}
}
mysql_close($connid);
echo "
";