From: "Nick Wilson" <[EMAIL PROTECTED]>
> * 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
yeah, the "+" modifier thinks you mean you want to add them as integers...
use my previous post with the concat command and that works...
Tim.
At 09:20 AM 5/20/2004, Nick Wilson wrote:
* and then Nick Wilson declared
> > >pages of course... What I need to do, is add to the very end of each
> >
* and then Tim Traver declared
> If you know exactly what you need to append, then you can just do the
> update query directly.
>
> UPDATE tablename
> SET body=concat(body,'string to add')
Awesome, that did it. Thanks for taking the time to show me dude ;-)
--
Nick W
--
PHP General Mail
* and then Nick Wilson declared
>
> * and then Matt Matijevich declared
> > [snip]
> > Do I need to select the body, then add the text to
> > it, then UPDATE it
> > [/snip]
> >
> > that is what you want to do
>
>
> That's what I figured 2, but check the post above ;-)
Damn, looks like
* 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 lng tim
If you know exactly what you need to append, then you can just do the
update query directly.
UPDATE tablename
SET body=concat(body,'string to add')
that should do it...
Tim
At 09:04 AM 5/20/2004, Nick Wilson wrote:
Hi all,
First off, yeah, it's a dumb Q ;-) but I cant remember enuf about mysql
t
* and then Matt Matijevich declared
> [snip]
> Do I need to select the body, then add the text to
> it, then UPDATE it
> [/snip]
>
> that is what you want to do
That's what I figured 2, but check the post above ;-)
thanks mate..
--
Nick W
--
PHP General Mailing List (http://www.php.net
* and then Stuart declared
> Nick Wilson wrote:
> >I have a DB that has a field called 'body' -> it holds the body of html
> >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
[snip]
Do I need to select the body, then add the text to
it, then UPDATE it
[/snip]
that is what you want to do
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Nick Wilson wrote:
I have a DB that has a field called 'body' -> it holds the body of html
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"
will upda
Hi all,
First off, yeah, it's a dumb Q ;-) but I cant remember enuf about mysql
to know if I need a php script or it might be done from the command
line...
I have a DB that has a field called 'body' -> it holds the body of html
pages of course... What I need to do, is add to the very end of each
11 matches
Mail list logo