fetch_data(); } protected function fetch_data(){ $this->statuses=array(); $query = "select * from scan_request_status"; $result = pmb_mysql_query($query); if(pmb_mysql_num_rows($result)){ while($row = pmb_mysql_fetch_object($result)){ $this->statuses[]=new scan_request_status($row->id_scan_request_status); } } } public static function get_options($selected=0){ global $charset; $options = ''; $query = "select * from scan_request_status"; $result = pmb_mysql_query($query); if(pmb_mysql_num_rows($result)){ while($row = pmb_mysql_fetch_object($result)){ $options.= " id_scan_request_status==$selected ? " selected='selected' " : "").">".htmlentities($row->scan_request_status_label,ENT_QUOTES,$charset).""; } } return $options; } public function get_statuses() { return $this->statuses; } }