Re: [PHP] Simple MySQL/PHP Query

2004-05-20 Thread John W. Holmes
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

Re: [PHP] Simple MySQL/PHP Query

2004-05-20 Thread Tim Traver
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 > >

Re: [PHP] Simple MySQL/PHP Query

2004-05-20 Thread Nick Wilson
* 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

Re: [PHP] Simple MySQL/PHP Query

2004-05-20 Thread Nick Wilson
* 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

Re: [PHP] Simple MySQL/PHP Query

2004-05-20 Thread Nick Wilson
* 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

Re: [PHP] Simple MySQL/PHP Query

2004-05-20 Thread Tim Traver
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

Re: [PHP] Simple MySQL/PHP Query

2004-05-20 Thread Nick Wilson
* 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

Re: [PHP] Simple MySQL/PHP Query

2004-05-20 Thread Nick Wilson
* 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

Re: [PHP] Simple MySQL/PHP Query

2004-05-20 Thread Matt Matijevich
[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

Re: [PHP] Simple MySQL/PHP Query

2004-05-20 Thread Stuart
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

[PHP] Simple MySQL/PHP Query

2004-05-20 Thread Nick Wilson
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