TEXT fields - MySQL

[radley]

Hi, I've created a database that has a TEXT field called newsmsg. I inserted a record to that field, and when I tried to display it, it output 'Array'. I wonder whats wrong... Any help would be appreciated.

--Rad

[[deleted]]

Sounds like you have actually tried to insert a value contained within an array, but instead have inserted the array without it\'s offset. I.e., you inserted this:

$array

rather than this:

$array[1]

I\'d check what you are inserting, as I think this is a PHP coding problem rather than a MySQL problem...

Matt
codewalkers.com

[nevermore2181]

Becareful, because statements where you include the array in the query could cause you trouble. For instance:

$query = "update table set data='$array[1]' where data != ''";
mysql_query($query);

This has the unfortunate side effect of only putting $array into the string, without the identifier to the stored value of [1] in the way. Much like $array . "[1]". Which could cause all sorts of issues.

Instead, separate the array variable from the string like this:

$query = "update table set data='" . $array[1] . "' where data != ''";
mysql_query($query);