[SOLVED] array get one

[proctk]

Below is code that uploads images to a file folder and puts information about the image in a mysql table.

 

I'm trying to figure how to send the file name from the first file field to another table called albumNames.

 

The update query would look like this

 

The variable '$otheralbum_cover' is where I'm having a hard time

 

mysql_query("UPDATE albumNames SET album_cover = '$otheralbum_cover' WHERE album= '$albumName' AND user_id = '$user_id'")or die ("Link Create Error:" .mysql_error());

 

// upload Images
if(isset($_POST['upLoadImages'])){
foreach ($_FILES['file']['tmp_name'] as $i => $val) :
if (is_uploaded_file($_FILES['file']['tmp_name'][$i])) {
// This is the temporary file created by PHP
$uploadedfile = $HTTP_POST_FILES['file']['tmp_name'][$i];

// Create an Image from it so we can do the resize
$src = imagecreatefromjpeg($uploadedfile);

// Capture the original size of the uploaded image
list($width,$height)=getimagesize($uploadedfile);

// For our purposes, I have resized the image to be
// 600 pixels wide, and maintain the original aspect
// ratio. This prevents the image from being "stretched"
// or "squashed". If you prefer some max width other than
// 600, simply change the $newwidth variable
$newwidth=450;
$newheight=($height/$width)*450;
$tmp=imagecreatetruecolor($newwidth,$newheight);


// this line actually does the image resizing, copying from the original
// image into the $tmp image
imagecopyresampled($tmp,$src,0,0,0,0,$newwidth,$newheight,$width,$height);

// now write the resized image to disk. I have assumed that you want the
// resized, uploaded image file to reside in the ./images subdirectory.
$filename = "../user_images/". $user_name."-".$HTTP_POST_FILES['file']['name'][$i];

imagejpeg($tmp,$filename,100);

imagedestroy($src);
imagedestroy($tmp); // NOTE: PHP will clean up the temp file it created when the request
// has completed.

$image_size = filesize($filename);
$image_name = $user_name."-".$HTTP_POST_FILES['file']['name'][$i];
$add_image = ("INSERT INTO image_files (image_name, image_size, user_id, create_date, album)
VALUES('$image_name', '$image_size', '$user_id', now(), '$album')");


$sql = mysql_query($add_image)or die("SQL Error: $add_image<br>" . mysql_error());
}
endforeach;
//

}

 

<form name="addImages" method="post" enctype="multipart/form-data" action="album.php?album=<?php echo $_GET['album']; ?>">
<table class="columntable">
  <tr>
    <td><input name="albumCover" type="file" id="albumCover" /></td>
    <td><input name="file[]" type="file" id="file[]" /></td>
    </tr>
  <tr>
    <td><input name="file[]" type="file" id="file[]" /></td>
    <td><input name="file[]" type="file" id="file[]" /></td>
  </tr>
  <tr>
    <td><input name="file[]" type="file" id="file[]" /></td>
    <td><input name="file[]" type="file" id="file[]" /></td>
  </tr>
  <tr>
    <td><input name="file[]" type="file" id="file[]" /></td>
    <td><input name="file[]" type="file" id="file[]" /></td>
    </tr>
  <tr>
    <td colspan="2">
          <input type="submit" name="upLoadImages" value="Add Photos" />          
	  <input name="clear" type="reset" id="clear" value="Reset" />  </td>
    </tr>
</table>
</form>

[lightningstrike]

$otheralbum_cover = $_POST["file"][0];

 

I believe thats what you want.

[proctk]

thank you that worked