Select Series:
// Series
// If there is an incoming year and no series_id, select the series
if (!strlen($Series_ID) && strlen($Year))
{
$sql = "SELECT series_id
FROM event_data
WHERE YEAR(event_date) = $Year
LIMIT 1";
$sql_result = mysql_query($sql,$db) or sql_error($sql, mysql_error());
list($Series_ID) = mysql_fetch_array($sql_result);
mysql_free_result($sql_result);
}
// Retrieve the series
$sql = "SELECT DISTINCT series.series_id, series.series_desc
FROM series, event_data
WHERE event_data.series_id = series.series_id
OR event_data.series_id2 = series.series_id
OR event_data.series_id3 = series.series_id
OR event_data.series_id4 = series.series_id
ORDER BY series.series_id desc";
$sql_result = mysql_query($sql,$db) or sql_error($sql, mysql_error());
while (list($Series_ID1, $Name) = mysql_fetch_array($sql_result))
{
if (!strlen($Series_ID))
$Series_ID = $Series_ID1;
$selected = $Series_ID == $Series_ID1 ? "selected='selected'" : "";
echo "$Name ";
}
mysql_free_result($sql_result);
?>
Select Round:
Please Select an Event
// Event
if (strlen($Series_ID))
{
$sql = "SELECT event_location, event_id, event_name
FROM event_data
WHERE series_id = $Series_ID
OR series_id2 = $Series_ID
OR series_id3 = $Series_ID
OR series_id4 = $Series_ID
ORDER BY event_date ASC";
$sql_result = mysql_query($sql,$db) or sql_error($sql, mysql_error());
while (list($Location, $Event_ID1, $Name) = mysql_fetch_array($sql_result))
{
$selected = $Event_ID == $Event_ID1 ? "selected='selected'" : "";
echo "$Name- $Location ";
}
mysql_free_result($sql_result);
}
?>
Select Class:
Please Select a Class
// Class
if (strlen($Event_ID))
{
$sql = "SELECT DISTINCT class.class_id, class.class_desc, event_data.event_id, class.sort_order, class.points_class
FROM class, event_data, event_entries
WHERE (event_entries.event_id = event_data.event_id)
AND (event_entries.class_id = class.class_id)
AND event_data.event_id = $Event_ID
AND (event_data.series_id = $Series_ID
OR event_data.series_id2 = $Series_ID
OR event_data.series_id3 = $Series_ID
OR event_data.series_id4 = $Series_ID)
ORDER BY event_data.event_id ASC, class.sort_order ASC, class.points_class ASC";
$sql_result = mysql_query($sql,$db) or sql_error($sql, mysql_error());
while (list($Class_ID, $Description, $Event_ID2, $SortOrder, $PointsClass) = mysql_fetch_array($sql_result))
echo "$Description ";
mysql_free_result($sql_result);
}
?>