|
St John's College Squad Members
connect_select();
$sql = "SELECT * FROM sjcbc_squad";
$result = mysql_query($sql);
$i = 0;
while($row = mysql_fetch_array($result)) {
$data[$i]['name'] = $row['name'];
$data[$i]['year'] = $row['year'];
$data[$i]['position'] = $row['position'];
$i++;
}
foreach ($data as $key => $row) {
$sort[$key] = $row['year'];
}
array_multisort($sort, SORT_DESC, $data);
echo "";
for($i=0 ; $i";
echo "".$data[$i]['year']." | ";
echo "".$data[$i]['name']." | ";
echo "".$data[$i]['position']." | ";
}
echo " "
?>
|
|
|