Re: INSERT statement
| From: | (Miles Thompson) | Date: | Mon, 21 May 2001 11:33:41 +0000 |
| Subject: | Re: INSERT statement | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9492@lists.php.net to get a copy of this message | ||
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 ]