multiple upload put image name in database

[fullyloaded]

hi i have this script that works great but now im trying to get it to add the names of the 3 images to my database anyone have any idea how this can be done? i tried everything i know of with no luck thanks...
Code:

<?php
$connection = mysql_connect("localhost", "????", "????");
mysql_select_db("????", $connection);
$uploaddir = "upload/";
$MaxSize = "600000";
$number_of_files = count($_FILES['userfile']);
for($i=0;$i<=$number_of_files;$i++) {
$filename_format = uniqid(Img_);
if (!$_FILES['userfile']['size'][$i] == 0)
{
if ($_FILES['userfile']['size'][$i] > $MaxSize)
{
echo "ERROR: file too big";
exit;}
$tempfile = $_FILES['userfile']['tmp_name'][$i];
$uploadfile = $_FILES['userfile']['name'][$i];
$extension = $_FILES['userfile']['type'][$i];
if (strstr($extension,"jpeg"))
{
$extension=".jpg";
}
elseif (strstr($extension,"gif"))
{
$extension=".gif";
}
elseif (strstr($extension,"png"))
{
$extension=".png";
}
else
{
echo "ERROR: Only gif/jpeg/png allowed.";
exit;
}
if(copy($tempfile, $uploaddir.$uploadfile))
{
echo "Copy Successfull!";
}
else
{
echo "ERROR: something happened trying to copy the temp file to the folder";
}
if(rename($uploaddir.$uploadfile,$uploaddir.$filename_format.$extension))
{
}else{
$query = "INSERT INTO photos (image1, image2, image3) VALUES ('WHAT TO PUT HERE?','HERE','AND HERE')";  

$result = mysql_query($query);
echo " and renamed to $filename_format$extension";
}
}
else
{
echo "ERROR: Problem renaming the file.. $uploadfile";
}
}
?>

[Damian_]

I hope this will help, this is a small snippet of what i have written, which works! but it is for an oracle database but the same principle applies

if(isset($_POST['submit'])){
$fn = $_POST['foreignkey'];
 $imgNumb=$pointer; //This the "pointer" to images
 $DestinationDir="publicimages/hire/";  //Place the destination dir here
 $ThumbDir="publicimages/hire/thb/";  //Place the thumb dir here
 $remove = array(".jpg", ".JPG", ".gif", ".GIF", ".PNG", ".png", " ");
   while($_FILES["file".$imgNumb]["tmp_name"]){
          $Unique=microtime(); // We want unique names, right?
		  $Unique=str_replace($remove, "" ,$_FILES['file'.$imgNumb]["name"]);

         $XL=$DestinationDir.$Unique."_".$imgNumb."_xl.jpg";
		 $XLa = $Unique."_".$imgNumb."_xl.jpg";

		  $L=$DestinationDir.$Unique."_".$imgNumb."_l.jpg";
		  $La = $Unique."_".$imgNumb."_l.jpg";

		  $m = $DestinationDir.$Unique."_".$imgNumb."_m.jpg";
		  $ma = $Unique."_".$imgNumb."_m.jpg";

		  $s=$DestinationDir.$Unique."_".$imgNumb."_s.jpg";
		  $sa = $Unique."_".$imgNumb."_s.jpg";

          $Thumb=$ThumbDir.$Unique."_".$imgNumb."_t.jpg";
		  $Timagea = $Unique."_".$imgNumb."_t.jpg";

          imgReisize($_FILES["file".$imgNumb]["tmp_name"], $XL, $L, $m, $s, $Thumb);


include('oracleonnect.php');

//this is bit i think you will most interested in: (You can't put more than one record in one go)

$query1 = oci_parse($conn,"INSERT INTO WEBEQUIPMENT.IMAGES(PID,I_ID, XL_IMAGE, L_IMAGE, M_IMAGE, S_IMAGE, T_IMAGE) VALUES ('".$fn."',IMGID_SEQ.NEXTVAL, '".$XLa."', '".$La."', '".$ma."', '".$sa."', '".$Timagea."')");



ociexecute($query1);

// as you can see i have looped this query until my imgNumb equals the pointer i have set.

          $imgNumb++;
   }

I hope this helps?

[fullyloaded]

Thanks a lot i will give it a try...