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