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