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