putting array values in mysql database trouble

[brem13]

hey, im trying to take a filename from an array and put it into a mysql database, but its not storing it

any help?

mysql_query("UPDATE $table SET mainPic = '$file_name[$i]' WHERE email = '$email'");

 

[brem13]

the array is stored in $file_name[$i] and it just posts a blank to the field in the database, but if i remove the [$i] it will post 'Array' into the field

[skurai]

how are you storing the files into the array? can you post more code?

[DavidAM]

I think there are two things you need to do here. 

1) since the variable inside the literal string is an array, mark it with cury braces;

 

mysql_query("UPDATE $table SET mainPic = '{$file_name[$i]}' WHERE email = '$email'");

 

2) you definitely need to escape the value - to do this we have to pull it out of the literal (so #1 no longer applies) - unless you escaped it when you put it in the array.

 

$file = mysql_real_escape_string($file_name[$i]);
mysql_query("UPDATE $table SET mainPic = '$file' WHERE email = '$email'");

 

you need to escape the $email address as well if haven't already.