combining strings

[mlcheatham]

This is likely a simple problem, but I can't seem to make it work...

I need to combine two strings. 'comments' resides in an SQL database ("Scores") and $comments is the additional text I'd like to add to the existing 'comments' string.

Using the code below, if 'comments' is "review 1" and $comments is "review 2", the result is "Resource id #2 review 2".

$sql = "SELECT comments from Scores WHERE idAbstract='$idAbstract'";
$result = mysql_query($sql);
$text = $result." ".$comments;

$sql = "UPDATE Scores SET comments='$text' WHERE idAbstract='$idAbstract'";

$result = mysql_query($sql);

Any suggestions will be appreciated

[LordShryku]

You can probably just save a step, and eliminate the select query by concating in your update.

$sql = "UPDATE Scores 
           SET comments = concat(comments, '".$comments."')
         WHERE idAbstract='$idAbstract'";
mysql_query($sql);

Beware of null values though...
http://dev.mysql.com/doc/mysql/en/String_functions.html