public static function getJobPowerNames($where = '1') { self::initDB(); $sql = 'select power_job.job_name,power_job.job_dept_id,power_job.job_company_id,power_jobpower.jobpower_id from `' . self::$power_job . '` as power_job left join ' . self::$power_jobpower . ' as power_jobpower on power_job.job_id=power_jobpower.jobpower_job_id where ' . $where; //echo $sql; if ($result = self::$dbConn->query($sql)) { $rt = array(); while ($data = self::$dbConn->fetch_assoc($result)) { $rt = array($data['jobpower_id'], $data['job_company_id'], $data['job_name'], $data['job_dept_id']); } return $rt; } self::$errCode = '1406'; self::$errMsg = "Get Job Names error"; return false; }