[SOLVED] Longtext

[Cless]

I have a longtext field, and all rows are similar to:

 

1,6,2,8

 

Which is an array..

 

Whenever I try to do something like:

 

mysql_query("UPDATE table SET array= array + ',5'");

 

...it converts the whole row to an integer. Any function or something that can be used to bypass this?

 

Thanks.

[wildteen88]

Use the MySQL concat() function

 

mysql_query("UPDATE table SET array=CONCAT(array, ',5')");

[Cless]

Thanks!