public static function getCoefficientSampleTypeName() { self::initDB(); $sql = "SELECT a.sampleTypeId,b.typeName FROM qc_sample_coefficient a,qc_sample_type b where a.sampleTypeId=b.id group by a.sampleTypeId"; $query = self::$dbConn->query($sql); if ($query) { $ret = self::$dbConn->fetch_array_all($query); return $ret; } else { self::$errCode = "2501"; self::$errMsg = "getCoefficientSampleTypeName"; return false; } }