Thread: php update problems

> Mike Sears wrote:
>
> Having a slight problem w/ my postgres database. for some reaons its
> no longer updating anymore, and for what reason I'm unsure
>
> if I'm right then the below "should" update the table I'm working in,
> though it doesn't. Is ther indeed something wrong here?
>
> <?
> require("dbconect.inc.php");
>
> $result = pg_exec($db,
>         "UPDATE news
> SET date='$date' topic='$topic' body='$body' person='$person'
> WHERE date='$date2' topic='$topic2' body='$body2' person='$person2'
> id2='$id';" );

UPDATE news SET date='$date', topic='$topic', body='$body',
person='$person' WHERE date='$date2' AND topic='$topic2' AND
body='$body2' AND person='$person2' AND id2='$id';

Cheers,
                    Andrew.
--
_____________________________________________________________________
            Andrew McMillan, e-mail: Andrew@cat-it.co.nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

many thanks both andrew and ryan =)

----- Original Message -----
From: "ryan" <ryan@bel.bc.ca>
To: "Mike Sears" <msears@vianet.ca>
Cc: "pgsql-general" <pgsql-general@postgresql.org>
Sent: Tuesday, August 22, 2000 2:40 PM
Subject: Re: [GENERAL] php update problems


> > Mike Sears wrote:
> >
> > Having a slight problem w/ my postgres database. for some reaons its
> > no longer updating anymore, and for what reason I'm unsure
> >
> > if I'm right then the below "should" update the table I'm working in,
> > though it doesn't. Is ther indeed something wrong here?
> >
> > <?
> > require("dbconect.inc.php");
> >
> > $result = pg_exec($db,
> >         "UPDATE news
> > SET date='$date' topic='$topic' body='$body' person='$person'
> > WHERE date='$date2' topic='$topic2' body='$body2' person='$person2'
> > id2='$id';" );
>
> Hi,
>
> Your SQL looks badly formed.
> The brief syntax of UPDATE is:
>
> UPDATE <tablename> SET col1=val1, col2=val2, ..., coln=valn WHERE
> condition1 AND condition2 ;
>
> so basically you're missing 'AND' between each of the where clauses, you
> don't have commas.
>
> If the update returns '0 rows altered' then you know someone else has
> modified the data from under you.
>
> Regards,
> -ryan
>
>
> --
> Ryan Rawson
> System Administrator
> Binary Environments Ltd.
> ryan@bel.bc.ca
>