2. PHPRunner General questions
  3. Update Field after record updated
This topic is locked

Update Field after record updated

 		11/19/2008 11:03:20 AM
PHPRunner General questions
buddy author

I am trying to update a field with the contents of 2 fields "After Record UPdated"
Here is what I am using but I must be missing something because I get PHP errors..
global $conn;
$strUpdate="UPDATE DataPath_Outsourcer SET New_OS_Comments = concat(DriverAuthor,Enter Comment)";
db_exec($strUpdate,$conn);
Thanks in advance for your help.
J
 		Jane 11/20/2008

Buddy,
here is a sample:

$strUpdate="UPDATE DataPath_Outsourcer SET New_OS_Comments = concat(`DriverAuthor`,' - ',`Enter Comment`), `Enter Comment`=''";

db_exec($strUpdate,$conn);