public function toSql()
    {
        $sql = 'select ';

        // Adding the select clause
        if (is_null($this->select)) {
            $sql .= '* from `' . $this->table .'`';
        } else {
            $sql .= $this->select . ' from `' . $this->table . '`';

            $this->select = null;
        }

        // Adding the join clause
        if (!is_null($this->join)) {
            $sql .= ' ' . $this->join;

            $this->join = null;
        }

        // Adding the where clause
        if (!is_null($this->where)) {
            $sql .= ' where ' . $this->where;

            $this->where = null;
        }

        // Addition of the order clause
        if (!is_null($this->order)) {
            $sql .= ' ' . $this->order;

            $this->order = null;
        }

        // Adding the limit clause
        if (!is_null($this->limit)) {
            $sql .= ' limit ' . $this->limit;

            $this->limit = null;
        }

        // Adding the group clause
        if (!is_null($this->group)) {
            $sql .= ' group by ' . $this->group;

            $this->group = null;

            if (!is_null($this->havin)) {
                $sql .= ' having ' . $this->havin;
            }
        }

        return $sql.';';
    }
public function toSql()
    {
        $sql = 'select ';

        // Adding the select clause
        if (is_null($this->select)) {
            $sql .= '* from `' . $this->table .'`';
        } else {
            $sql .= $this->select . ' from `' . $this->table . '`';

            $this->select = null;
        }

        // Adding the join clause
        if (!is_null($this->join)) {
            $sql .= ' ' . $this->join;

            $this->join = null;
        }

        // Adding the where clause
        if (!is_null($this->where)) {
            $sql .= ' where ' . $this->where;

            $this->where = null;
        }

        // Addition of the order clause
        if (!is_null($this->order)) {
            $sql .= ' ' . $this->order;

            $this->order = null;
        }

        // Adding the limit clause
        if (!is_null($this->limit)) {
            $sql .= ' limit ' . $this->limit;

            $this->limit = null;
        }

        // Adding the group clause
        if (!is_null($this->group)) {
            $sql .= ' group by ' . $this->group;

            $this->group = null;

            if (!is_null($this->havin)) {
                $sql .= ' having ' . $this->havin;
            }
        }

        return $sql.';';
    }
public function toSql ( ) { $ sql = 'select ' ; // Adding the select clause if ( is_null ( $ this -> select ) ) { $ sql .= '* from `' . $ this -> table . '`' ; } else { $ sql .= $ this -> select . ' from `' . $ this -> table . '`' ; $ this -> select = null ; } // Adding the join clause if ( ! is_null ( $ this -> join ) ) { $ sql .= ' ' . $ this -> join ; $ this -> join = null ; } // Adding the where clause if ( ! is_null ( $ this -> where ) ) { $ sql .= ' where ' . $ this -> where ; $ this -> where = null ; } // Addition of the order clause if ( ! is_null ( $ this -> order ) ) { $ sql .= ' ' . $ this -> order ; $ this -> order = null ; } // Adding the limit clause if ( ! is_null ( $ this -> limit ) ) { $ sql .= ' limit ' . $ this -> limit ; $ this -> limit = null ; } // Adding the group clause if ( ! is_null ( $ this -> group ) ) { $ sql .= ' group by ' . $ this -> group ; $ this -> group = null ; if ( ! is_null ( $ this -> havin ) ) { $ sql .= ' having ' . $ this -> havin ; } } return $ sql . ';' ; }
Formats the select request

@return string
Formats the select request