public function createCourseOptionsSelected($selected = null) { //if(self::$instResultSet==null){ $getAllCoursesSql = "select * from iseries_courses"; $resultSet = mysql_query($getAllCoursesSql) or die('Unable to retrieve instructor list'); self::$courseResultSet = $resultSet; //} $resultSet = self::$courseResultSet; $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]; if ($selected == $row[0]) { $courseOptions .= " selected=selected"; } $courseOptions .= ">"; $name = $row[1] . $row[2] . $row[3] . "-" . $row[4]; $courseOptions .= $name; $courseOptions .= "</option>"; } return $courseOptions; }