/** * Compiles the select statement based on the other functions called and returns the query string. * * @param string table name * @param string limit clause * @param string offset clause * @return string sql string */ public function compile($table = '', $limit = NULL, $offset = NULL) { if ($table != '') { $this->from($table); } if (!is_null($limit)) { $this->limit($limit, $offset); } $sql = $this->_driver->select(get_object_vars($this)); $this->reset(); return $sql; }