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; }