Blob error to get data from mysql

[jesada]

Hi

How to get data from a field "BLOB", can i paste it to a variable before store to other table ( field is the same )

My error :

       $gdata[$i] = mysql_result($result , $i, "gdata");

but I can not use $gdata[$i] to insert to database:

$sql = "INSERT INTO tb_gallery ( gdes, gname, gsize, gtype, gdata, gkey)";

$sql = $sql."VALUES ( '$gdes[$i]', '$gname[$i]', '$gsize[$i]', '$gtype[$i]', '$gdata', '$gkey[$i]' );";
$result = mysql_query($sql) or die(mysql_error());

Please help me to solve this;

Thanks for your kindness;

[DonChris]

you get the data into $gdata[$i]

 $gdata[$i] = mysql_result($result , $i, "gdata");

but later you are inserting $gdata - it's an array
I guess in your database you'll find 'Array' and NOT the expected data...

$sql = "INSERT INTO tb_gallery ( gdes, gname, gsize, gtype, gdata, gkey)";
$sql = $sql."VALUES ( '$gdes[$i]', '$gname[$i]', '$gsize[$i]', '$gtype[$i]', '-----> $gdata <-----', '$gkey[$i]' );";