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 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 html page, one short peice of text.. not a footer, just an adition to every page.
How do I do that? - Do I need to select the body, then add the text to it, then UPDATE it, or can i just appened somthing to what's already there?
Many thx! -- Nick W
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php