Select a year below to see the men's and women's crews
who rowed in that year.
connect_select();
$i = 1996;
$j = 1997;
$k = 1;
while ($k == 1) {
$sql = "SELECT * FROM sjcbc_crews WHERE (event!='novice' AND year=".$j.") OR (event='novice' AND year=".$i.")";
$result = mysql_query($sql);
if(mysql_affected_rows() == 0) {
$k = 0;
} else {
$i++;
$j++;
}
}
while($i>1996) {
$i--;
$j--;
echo "";
$name = "$i - $j";
echo "$name";
}
?>
Older Crews
|