AdamB7586 / pdo-dbal

     * @param int $limit The number of results you want to return 0 is default and will update all results that match the query, else should be formated as a standard integer

     * @return boolean Returns true if update is successful else returns false

     */

    public function update($table, $records, $where = array(), $limit = 0){

        unset($this->values);

        $this->sql = sprintf("UPDATE `%s` SET %s %s%s;", $table, $this->fields($records), $this->where($where), $this->limit($limit));

        $this->executeQuery(false);

        return $this->numRows() ? true : false;

    }

    /**

     * Deletes records from the given table based on the variables given

     * @param array $where This should be an array of for the where statement

     * @param int $limit The number of results you want to return 0 is default and will delete all results that match the query, else should be formated as a standard integer

     */

    public function delete($table, $where, $limit = 0){

        unset($this->values);

        $this->sql = sprintf("DELETE FROM `%s` %s%s;", $table, $this->where($where), $this->limit($limit));

        $this->executeQuery(false);

        return $this->numRows() ? true : false;

    }

    /**

     * Count the number of return results