public function fieldSelectAll($table, $fields, $where, $orderBy = null)
    {
        $table = $this->getTableName($table);

        $query = "SELECT ";

        $query .= $this->selectFields($fields);

        $query .= " FROM " . $table . " ";

        $params = null;
        if ($where !== self::NO_WHERE_CLAUSE) {
            $query .= "WHERE " . $this->where($where, $params);
        }

        if ($orderBy) {
            $query .= $this->orderBy($orderBy) . " ";
        }

        return $this->query($query, $params);
    }
public function fieldSelectAll($table, $fields, $where, $orderBy = null)
    {
        $table = $this->getTableName($table);

        $query = "SELECT ";

        $query .= $this->selectFields($fields);

        $query .= " FROM " . $table . " ";

        $params = null;
        if ($where !== self::NO_WHERE_CLAUSE) {
            $query .= "WHERE " . $this->where($where, $params);
        }

        if ($orderBy) {
            $query .= $this->orderBy($orderBy) . " ";
        }

        return $this->query($query, $params);
    }
public function fieldSelectAll ( $ table , $ fields , $ where , $ orderBy = null ) { $ table = $ this -> getTableName ( $ table ) ; $ query = "SELECT " ; $ query .= $ this -> selectFields ( $ fields ) ; $ query .= " FROM " . $ table . " " ; $ params = null ; if ( $ where !== self :: NO_WHERE_CLAUSE ) { $ query .= "WHERE " . $ this -> where ( $ where , $ params ) ; } if ( $ orderBy ) { $ query .= $ this -> orderBy ( $ orderBy ) . " " ; } return $ this -> query ( $ query , $ params ) ; }
Create a standard select statement and return the result
Create a standard select statement and return the result