Re: [GENERAL] Error using update

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