I need to add some data to a row called "data".
At the moment I am using the Update command but this is overwriting the existing data. I need to hold the existing data and just add the new one to it.
I need to add some data to a row called "data".
At the moment I am using the Update command but this is overwriting the existing data. I need to hold the existing data and just add the new one to it.
Use this
$model::$db->insert('UPDATE table SET data = CONCAT(data, "' . $link . '") WHERE id = "'. $id . '"');
It will concat your data with existing data