Varsity

[insert_php]
$username = $_POST[‘username’];
$password = $_POST[‘password’];
mysql_connect(“mysql.torontowildcats.com”,”torontowildcats”,”yhwgg33805″);
mysql_select_db(“torontowildcats”);
[/insert_php]

[insert_php]
$result = mysql_query(“SELECT count(‘ID’) as COUNT FROM `registration` where team=’Varsity’ and SummerConfirmed=’Yes’ and role=’Player’ order by ID desc “) or trigger_error(mysql_error());$row = mysql_fetch_array($result);
$count = $row[‘COUNT’];
echo ”  $count  are eligible for 2014 Summer “;
[/insert_php]

[insert_php]

echo “<table class=’list_table’ cellpadding=’2′ cellspacing=’1′ >”;
echo “<tr>”;
echo “<th>PHOTO</th>”;
echo “<th><b>#</th>”;
echo “<th><b>ST</th>”;
echo “<th><b>FIRST</th>”;
echo “<th><b>LAST</th>”;
echo “<th><b>SCHOOL</th>”;
echo “<th><b>POS 1</th>”;
echo “<th><b>POS 2</th>”;
echo “<th><b>GRAD YR</th>”;
echo “<th><b>SCHOOLCOACH</th>”;
echo “<th><b>GRAD?</th>”;
echo “<th><b>HT FT</th>”;
echo “<th><b>HT IN</th>”;
echo “<th><b>WT</th>”;
echo “<th><b>40 TIME</th>”;
echo “<th><b>T TEST</th>”;
echo “<th><b>225 REPS</th>”;
echo “<th><b>185 REPS</th>”;
echo “<th><b>EXP</th>”;
echo “</tr>”;
$result = mysql_query(“SELECT * FROM `registration` where team=’Varsity’ and SummerConfirmed=’Yes’ and role=’Player’ order by ID desc”) or trigger_error(mysql_error());
while($row = mysql_fetch_array($result)){
foreach($row AS $key => $value) { $row[$key] = stripslashes($value);

}
echo “<tr>”;
echo “<td valign=’top’><img src='”. nl2br( $row[‘Pic’]) .”‘></td>”;
echo “<td valign=’top’>” . nl2br( $row[‘Num’]) . “</td>”;
echo “<td valign=’top’>” . nl2br( $row[‘Status’]) . “</td>”;
echo “<td valign=’top’>” . nl2br( $row[‘FName’]) . “</td>”;
echo “<td valign=’top’>” . nl2br( $row[‘LName’]) . “</td>”;

echo “<td valign=’top’>” . nl2br( $row[‘HighSchool’]) . “</td>”;
echo “<td valign=’top’>” . nl2br( $row[‘Position_1′]) . “</td>”;
echo “<td valign=’top’>” . nl2br( $row[‘Position_2′]) . “</td>”;
echo “<td valign=’top’>” . nl2br( $row[‘Grad_Year’]) . “</td>”;
echo “<td valign=’top’>” . nl2br( $row[‘HighSchoolCoach’]) . “</td>”;
echo “<td valign=’top’>” . nl2br( $row[‘Graduating’]) . “</td>”;
echo “<td valign=’top’>” . nl2br( $row[‘HeightFeet’]) . “</td>”;
echo “<td valign=’top’>” . nl2br( $row[‘HeightInches’]) . “</td>”;
echo “<td valign=’top’>” . nl2br( $row[‘Weight’]) . “</td>”;
echo “<td valign=’top’>” . nl2br( $row[‘x40Time’]) . “</td>”;
echo “<td valign=’top’>” . nl2br( $row[‘TTest’]) . “</td>”;
echo “<td valign=’top’>” . nl2br( $row[‘x225Reps’]) . “</td>”;
echo “<td valign=’top’>” . nl2br( $row[‘x185Reps’]) . “</td>”;
echo “<td valign=’top’>” . nl2br( $row[‘YearsOfFootball’]) . “</td>”;

echo “</tr>”;
}
echo “</table>”;

[/insert_php]