Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org (8.8.8/8.7.5) with ESMTP id HAA01683 for ; Tue, 30 Jun 1998 07:56:49 -0400 (EDT) Received: from smtp01.wxs.nl (smtp01.wxs.nl [195.121.6.61]) by trends.net (8.8.8/8.8.8) with ESMTP id HAA11000 for ; Tue, 30 Jun 1998 07:20:47 -0400 (EDT) Received: from hrs_nt ([195.121.88.97]) by smtp01.wxs.nl (Netscape Messaging Server 3.54) with SMTP id AAC3002; Tue, 30 Jun 1998 13:17:00 +0200 From: "Rob den Boer" To: "Joao Paulo Felix" Cc: "Pgsql-Sql" Subject: RE: [GENERAL] Updating multiple fields Date: Tue, 30 Jun 1998 13:16:38 +0200 Message-ID: <000d01bda418$8ce79700$67032e9f@hrs_nt.hrs> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 In-Reply-To: <3593D866.7C23664E@cyclades.com> X-mimeole: Produced By Microsoft MimeOLE V4.72.2106.4 Importance: Normal Hi Joao, > -----Original Message----- > From: owner-pgsql-general@hub.org [mailto:owner-pgsql-general@hub.org]On > Subject: [GENERAL] Updating multiple fields How about this: pg_Exec($conn, "UPDATE options SET description = '$description' , info = '$info' , title = $title' WHERE product = '$product' AND title = '$old_title';"); regards Rob den Boer