TJ Woodruff ONLINE

Click the column headers to sort by that column
$race_result = mysql_query("SELECT * FROM results ORDER BY race_date DESC")
or die(mysql_error());

// store the record of the "example" table into $row
$race_row = mysql_fetch_array( $race_result );
// Print out the contents of the entry

echo '

‘;
echo “

“;
// keeps getting the next row until there are no more to get
while($race_row = mysql_fetch_array( $race_result )) {
// Print out the contents of each row into a table
echo “

“;
}

echo “

Date	Race	Place
” . $race_row['race_date'] . “	” . $race_row['race_desc'] . ” – ” . $race_row['race_type'] . “	“; $dnfchk = $race_row['race_place']; if ($dnfchk == 0) { echo “999″; } else { echo $race_row['race_place']; } echo “

“;

?>