Thread: php update problems

php update problems

From
"Mike Sears"
Date:
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';" );
 
pg_colse($db);
?>
 
Mike

Re: php update problems

From
Andrew McMillan
Date:
> 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

Re: php update problems

From
"Mike Sears"
Date:
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
>