I don't use PostgresSQL, but the SQL can't be that different:
INSERT INTO table (column2,column4) VALUES ('$x','$y') WHERE column1 =
'$z'
//Loose the brackets after the WHERE clause, and add single quotes
//around your variable.
Russ
INSERT INTO table (column2,column4) VALUES ('$x','$y') WHERE (column1 =
$z) Php shows:
On Mon, 21 May 2001 10:54:05 +0200 Bartek Pawlik
<[EMAIL PROTECTED]> 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 ]
#-------------------------------------------------------#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
t: +44 (0)1223 363271 x 2331
www.theruss.com
#-------------------------------------------------------#
--
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]