/**
* 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;
}