Exemple #1
0
 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;
 }