Re: [GENERAL] Error using update - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: [GENERAL] Error using update
Date
Msg-id Pine.LNX.4.21.0002220050070.349-100000@localhost.localdomain
Whole thread Raw
In response to Error using update  (Pete Bass <Peter.Bass@baedsl.co.uk>)
List pgsql-general
On 2000-02-21, Pete Bass mentioned:

> I'm running Postgres 6.3 with PHP 2 as a web based db application.

I'd strongly advise you to update both of these, since hardly anyone
around here will be able to help you much with these.

> a single record, but instead of only the specified record being updated,
> all the records had the same field updated.
>
> the code used to update the field(s) for a record is:
>  $result=pg_Exec($conn,"update $spr set $set where sprid='$sprid'");

Perhaps $set contains a semicolon?

> Also, is it possible to return the number of rows that have been
> updated?

pg_numrows()

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] copying databases
Next
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] Passwords