insert multiple file paths

[Decipher19]

hi there,

 

I am able to upload multiple files but i would like to store the file paths from the array i declared into the database. I'm not sure whether my query is correct but here it is. It turned up funny in the database when I checked. just ".","/","l" respectively in each picPath. the full file path was not inserted. I used a for loop for the multiple file upload. can someone please help?

 

$sql="INSERT INTO picturesimage (picPath1, picPath2, picPath3)
VALUES
('$uploadfile[0]','$uploadfile[1]','$uploadfile[2]')";
$result = executes($sql);

[Wildbug]

Is executes() a function you've created?

 

I don't know if this is your problem, but you should probably quote the data you plan to input:

 

$sql = sprintf('INSERT INTO picturesimage (picPath1, picPath2, picPath3) VALUES("%s","%s","%s")',
mysql_real_escape_string($uploadfile[0]),
mysql_real_escape_string($uploadfile[1]),
mysql_real_escape_string($uploadfile[2])
);