public function fetchColumn($table, $where = array(), $fields = '*', $colNum = 0, $order = array(), $cache = true) {
        $this->buildSelectQuery(SafeString::makeSafe($table), $where, $fields, $order, 1);
        $result = $this->executeQuery($cache);
        if(!$result) {
            $column = $this->query->fetchColumn(intval($colNum));
            if($cache && $this->cacheEnabled) {$this->setCache($this->key, $column);}
            return ($column ? $column : false);
        }
        return false;
    }
public function fetchColumn($table, $where = array(), $fields = '*', $colNum = 0, $order = array(), $cache = true) {
        $this->buildSelectQuery(SafeString::makeSafe($table), $where, $fields, $order, 1);
        $result = $this->executeQuery($cache);
        if(!$result) {
            $column = $this->query->fetchColumn(intval($colNum));
            if($cache && $this->cacheEnabled) {$this->setCache($this->key, $column);}
            return ($column ? $column : false);
        }
        return false;
    }
public function fetchColumn ( $ table , $ where = array ( ) , $ fields = '*' , $ colNum = 0 , $ order = array ( ) , $ cache = true ) { $ this -> buildSelectQuery ( SafeString :: makeSafe ( $ table ) , $ where , $ fields , $ order , 1 ) ; $ result = $ this -> executeQuery ( $ cache ) ; if ( ! $ result ) { $ column = $ this -> query -> fetchColumn ( intval ( $ colNum ) ) ; if ( $ cache && $ this -> cacheEnabled ) { $ this -> setCache ( $ this -> key , $ column ) ; } return ( $ column ? $ column : false ) ; } return false ; }
Returns a single column value for a given query
@param string $table This should be the table you wish to select the values from
@param array $where Should be the field names and values you wish to use as the where query e.g. array('fieldname' => 'value', 'fieldname2' => 'value2', etc).
@param array $fields This should be the records you wis to select from the table. It should be either set as '*' which is the default or set as an array in the following format array('field', 'field2', 'field3', etc).
@param int $colNum This should be the column number you wish to get (starts at 0)
@param array $order This is the order you wish the results to be ordered in should be formatted as follows array('fieldname' => 'ASC') or array("'fieldname', 'fieldname2'" => 'DESC') so it can be done in both directions
@param boolean $cache If the query should be cached or loaded from cache set to true else set to false
@return mixed If a result is found will return the value of the colum given else will return false
Returns a single column value for a given query