[thelist] Re: mysql update problem - solved

Dunstan Orchard dunstan at 1976design.com
Mon Mar 24 06:58:47 CST 2003


> > Dunstan asked:
> >
> > UPDATE newspost SET postdate = '$postdate', posttitle = '$posttitle',
> > postbody = '$postbody', poststatus = '$poststatus' WHERE (postid 
> > = '$postid')

> Dunstan's continual saviour, Rudy, replied:
>
> is postid numeric?

ah! that was it, I had to remove the '' from around the $postid value.

Now reads:

... WHERE (postid = $postid)


Thankyou thankyou,

- Dunstan :o)

---------------------------
Dorset, England
http://www.1976design.com/
http://www.orchard.it/
http://www.maccaws.org/


More information about the thelist mailing list