/** * get key value from table * * This function is being used to get key/value array from a specified table as per provided parameter. * * @param $key * @param $value * @param $table * @param $qry_options * * @author: azizabbas */ public function getKeyValueFromTable($key, $value, $table, $qry_options = "", $compileStr = false) { $result = array(); //---- run qry and return number of rows $sql = "SELECT `" . $key . "`, `" . $value . "` FROM `" . $table . "` " . $qry_options; $rs = $this->CR->db->runSQL($sql); foreach ($rs as $arr) { $index = $compileStr ? general::compileStringValue($arr[$key]) : $arr[$key]; $result[$index] = $arr[$value]; } return $result; }