Bartek,

Saw all the other replies, and they are correct, but what you want now is 
an UPDATE, not an INSERT. You have the record, you are amending it.

Miles

At 10:54 AM 5/21/01 +0200, Bartek Pawlik wrote:
>Hi,
>I have problem with INSERT statement in PostgresSQL v.7.0.3.
>In one script I insert values in column1,column3,column5.
>Later I want to fill column2 and column4.
>I use
>INSERT INTO table (column2,column4) VALUES ('$x','$y') WHERE (column1 = $z)
>  Php shows:
>
>Warning: PostgreSQL query failed: ERROR: parser: parse error at or near 
>"where" in file.php on line x
>
>
>Thanks in advance
>
>Bartek Pawlik
>Poland
>
>
>
>
>
>--
>26 maja - Dzień Matki. Wygraj kwiaty dla swojej Mamy!
>Do rozdania 75 bukietów z dostawą i życzeniami.
>[ http://zakupy.onet.pl/prezenty.asp?k=7 ]


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to