title: Store array in MySQL using PHP one by one
body: <p>Ii have stored an array list using</p>
  
  <pre><code>&lt;?php
  $array = array("foo", "bar", "hello", "world");
  include("mydb.php");
  $array_string=mysql_escape_string(serialize($array));
  mysql_query("insert into tsest (array) values('$array_string')",$con) or die("not updated");
  ?&gt;
  </code></pre>
  
  <p>now i want to update that field with a new array but don't delete previeus one i used</p>
  
  <pre><code>   &lt;?php
  $array = array("aaa");
  include("mydb.php");
  $array_string=mysql_escape_string(serialize($array));
  
  $sql= 'select * from tsest where uname = "manoj" ';    
      $result = mysql_query($sql,$con);
      $row = mysql_fetch_array($result);  
  $value=$row['array'];
  mysql_query('UPDATE tsest SET array="'.$array_string.'"'.$value.' where uname="manoj"',$con) or die("hello");
  
  ?&gt;
  </code></pre>
  
  <p>but it didn't work</p>