MDanz Posted October 2, 2009 Share Posted October 2, 2009 how do i add on to what already is in the cell in mysql? what i've done below i think will replace what is in the cell.. say i have 'dog' in the cell... i want to add on 'cat'.. in the cell it should say 'dog cat' .... rather than cat replacing dog. <?php mysql_connect("localhost", "Master", "password"); mysql_select_db("db"); $query2= mysql_query("UPDATE Stacks SET keywords='$name' WHERE id=44") or die (mysql_error()); ?> how can i add on to what already is in the keywords column? Quote Link to comment Share on other sites More sharing options...
cags Posted October 2, 2009 Share Posted October 2, 2009 I believe the syntax would be something like... UPDATE Stacks SET `keywords`=CONCAT(`keywords`, ' ', '$name') WHERE id=44 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.