Search for results by entering the between dates.

You can refine your search by selecting Grade, Competition or Oppsoition. These fields can also be left blank.

Between dates* to day,month,year e.g. 01-02-2002
Grade
Competition
Opposition
* = field must be filled in
= '$from_date' AND rf.result_fixture_date <= '$to_date' "; if (!$grade_id == 0) { $sql = $sql . "AND rf.grade_id = $grade_id "; } if (!$competition_id == 0) { $sql = $sql . "AND rf.competition_id = $competition_id "; } if (!$opposition_id == 0) { $sql = $sql . "AND rf.opposition_id = $opposition_id "; } $sql = $sql . "ORDER BY result_fixture_date desc"; $numresults=mysql_query($sql); $numrows=mysql_num_rows($numresults); $result = mysql_query($sql); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } while ( $row = mysql_fetch_array($result) ) { $result_fixture_date= $row["rfDate"]; $grade_desc = $row["grade_desc"]; $competition_desc = $row["competition_desc"]; $sex = $row["sex"]; $opposition_desc = $row["opposition_desc"]; $venue_desc = $row["venue_desc"]; $score = $row["score"]; $round_desc = $row["round_desc"]; if ($sex == "M") { $sex = "Men"; } else { $sex = "Women"; } ?>
result(s) found
Date Grade Competition Opposition Venue Score