Not sure if you're asking whether you can append info onto the end of a
database field without having to get the previous information, but you can. 

UPDATE table SET MyField=CONCAT(MyField,'Appended Text') WHERE Some_ID=5;

That would update the row identified by Some_ID = 5, and append "Appended
Text" to the end of MyField without a query to get the previous values. For
numeric fields, you can also increment them like this:

UPDATE table SET MyNumericField = MyNumericField + 1;

That would update all rows in table, incrementing every row's MyNumericField
value by 1.

- Jonathan

-----Original Message-----
From: Jason Wong [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 2:27 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] appending new entry to old entries


On Thursday 18 April 2002 16:51, Ron Allen wrote:
> I would like to make it so that my helpdesk section can append entries in
> their Master Station Log. Update replaces the entry....any clues??????

You would have to get the original value, append the new stuff then do
UPDATE.

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *


/*
There is very little future in being right when your boss is wrong.
*/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to