[RESOLVED] Appending data to MySQL field

[blackbox]

Hi all,

I am trying to append data to a field using the following:

$CommentAppend = "Test comments";

$updateSQL = "UPDATE InstantService SET Comments = CONCAT(COALESCE(Comments, $CommentAppend))  WHERE RecordID =". $_POST['RecordID'];

When I run this query I get the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'comments)) WHERE RecordID =56' at line 1

Can anyone see why this should not run.

Many thanks in advance for any help you can provide.

Blackbox

[NogDog]

Don't thing you need a coalesce in this case. I might use concat_ws() in order to add a space (or whatever separator you'd prefer).

$updateSQL = "
  UPDATE InstantService 
  SET Comments = CONCAT_WS(' ', Comments, '$CommentAppend') 
  WHERE RecordID =". (int)$_POST['RecordID'];

[blackbox]

Hi NogDog, thanks for this.