Add onto field when UPDATE mysql
Posted: Wed Apr 12, 2006 7:02 pm
Want to add onto a field at the end of the value in a mysql field.
In PHP if you wanted to add onto a string you would go :
$FieldList ='String';
$FieldList .=' Added Value';
print $FieldList;
Would return 'String Added Value', want to do the same thing when updating a row ..
Something like that
In PHP if you wanted to add onto a string you would go :
$FieldList ='String';
$FieldList .=' Added Value';
print $FieldList;
Would return 'String Added Value', want to do the same thing when updating a row ..
Code: Select all
mysql_query("UPDATE `users` SET 'FieldList'=+'Added Value' WHERE ....