Re: php update problems

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
>