[CarBoffin]

This is really frustrating as i did this yesterday but have forgotten how to do it today .

I want to add info from a form which has been submitted to a mysql database, which it does, but it doesn't insert the UPLOADED file name (only the tmp). I have all the fields in the right order in my table bit it still won't do it even though i have changed the variable from $screen to ".$_FILES['screen']['name']." which is used in the upload.


[CODE]
<?
copy ($_FILES['screen']['tmp_name'], "screens/".$_FILES['screen']['name'])
or die ("Could not upload");

echo "";
echo "Name: ".$_FILES['screen']['name']."";
echo "Size: ".$_FILES['screen']['size']."";
echo "Type: ".$_FILES['screen']['type']."";
echo "Copy Done....";
?>


<?
$username="MRSIN";
$password="******";
$database="games";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO en VALUES ('','$title','$author','$mini','$full',".$_FILES['screen']['name'].")";
mysql_query($query);

mysql_close();
print"Your Game has been added!";
?>
[CODE]


Thanks