Re: Simple MySQL/PHP Query
| From: | John W. Holmes | Date: | Thu, 20 May 2004 16:34:55 +0000 |
| Subject: | Re: Simple MySQL/PHP Query | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-186603@lists.php.net to get a copy of this message | ||
From: "Nick Wilson" <nick@stylesheet.org>
> * and then Nick Wilson declared....
> > > >pages of course... What I need to do, is add to the very end of each
> > > >html page, one short peice of text.. not a footer, just an adition to
> > > >every page.
> > >
> > > UPDATE table SET body = body + "text to append"
> >
> > Hehe, it's been such a loooong time since i did even the simplest SQL
> > work ;-)
>
> DAMN! - Good job i tested on the local DB not the live one!
> That wiped the entire DB and put a '0' in place of every body column?
>
> Here's what I did:
> update node set body = body + "\n\n<p>This is extra</p>";
>
> Anyone see what went wrong?
"string" + "string" == Zero...
concat()
---John Holmes...