public function fetchSingleRow($query, $type = 'ASSOC', $link = null)
{
$result = $this->tryQuery($query, $link, self::QUERY_STORE, false);
if ($result === false) {
return false;
}
// return false if result is empty or false
if (!$this->numRows($result)) {
return false;
}
switch ($type) {
case 'NUM':
$fetch_function = 'fetchRow';
break;
case 'ASSOC':
$fetch_function = 'fetchAssoc';
break;
case 'BOTH':
default:
$fetch_function = 'fetchArray';
break;
}
$row = $this->{$fetch_function}($result);
$this->freeResult($result);
return $row;
}