Re: Simple MySQL/PHP Query

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 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