public function createCourseOptions()
{
if (self::$courseOptions != null) {
return self::$courseOptions;
}
$getAllCoursesSql = "select * from iseries_courses";
$resultSet = mysql_query($getAllCoursesSql) or die('Unable to retrieve course list');
$courseOptions .= "<option></option>";
while ($row = mysql_fetch_array($resultSet, MYSQL_NUM)) {
$courseOptions .= "<option ";
$courseOptions .= "name=";
$courseOptions .= $row[1] . $row[2] . $row[3];
$courseOptions .= " value=" . $row[0];
$courseOptions .= ">";
$name = $row[1] . $row[2] . $row[3] . "-" . $row[4];
$courseOptions .= $name;
$courseOptions .= "</option>";
}
self::$courseOptions = $courseOptions;
}
