[Resolved] Mysql multiple file upload input

[BizBoy]

I'm trying to input multiple file names into a database but it only inputs one file name, all the files upload successfully, do i need an array?

if($act == "addnew")
{
	//Upload files
if ($_POST['MAX_FILE_SIZE'])
{
foreach ($_FILES["pic"]["error"] as $key => $error) {
   if ($error == UPLOAD_ERR_OK) {
       $tmp_name = $_FILES["pic"]["tmp_name"][$key];
       $name = $next_id."_".$_FILES["pic"]["name"][$key];
       move_uploaded_file($tmp_name, "$directory$name");
       echo $name;
		}
	}
	}
	$lctn = addslashes($lctn);
	$type = addslashes($type);
	$vews = addslashes($views);

mysql_query("INSERT INTO propdb SET ID = '$next_id', lctn = '$lctn', type = '$type', psize = '$psize', lsize = '$lsize', views = '$views', price = '$price', brooms = '$brooms', bhrooms = '$bhrooms', lounges = '$lounges', kitchens = '$kitchens', images = '$name'", $connection);
echo "The entry has been successfully added.";

};

[dalecosp]

Maybe the insert statement needs to be inside the loop?

[BizBoy]

if i do that it will repeat the entry as number of images :queasy:

Like this;

ID2
Type: Villa
Location: Spain
<image>

ID2
Type: Villa
Location: Spain
<image2>

ID2
Type: Villa
Location: Spain
<image3>

ID2
Type: Villa
Location: Spain
<image4>

[dalecosp]

Ok, maybe now I get it.

You might do this:

if($act == "addnew") 
{ 
    //Upload files 
if ($_POST['MAX_FILE_SIZE']) 
{ 

$namelist=array(); // we'll hold all the filenames here...

foreach ($_FILES["pic"]["error"] as $key => $error) { 
   if ($error == UPLOAD_ERR_OK) { 
       $tmp_name = $_FILES["pic"]["tmp_name"][$key]; 
       $name = $next_id."_".$_FILES["pic"]["name"][$key]; 
       move_uploaded_file($tmp_name, "$directory$name"); 
       echo $name; 
       $namelist[]=$name;
        } 
    } 
    } 
    $lctn = addslashes($lctn); 
    $type = addslashes($type); 
    $vews = addslashes($views); 

$insert_names=implode(",", $namelist); // make array a comma-seperated list

mysql_query("INSERT INTO propdb SET ID = '$next_id', lctn = '$lctn', type = '$type', psize = '$psize', lsize = '$lsize', views = '$views', price = '$price', brooms = '$brooms', bhrooms = '$bhrooms', lounges = '$lounges', kitchens = '$kitchens', images = '$insert_names'", $connection); // $insert_names, a list, added to db...
echo "The entry has been successfully added."; 

};

[BizBoy]

Working now tnx 😉