I've been trying to find a script to upload a file to a folder on the server and insert the name into a MySQL Database. I am very new to PHP and so I'm using Dreamweaver CS4 for 99% of my work. I got an upload script from this forum, Cheers Bokeh, which is working fine, and I went through the post I got it from and there were others trying to do the same thing as I am. I have tried a all of their methods and some others I have found around the net but for some reason I can't get it to add the name to the database.

Ok, so here is my code (very slightly edited from the original) without anything to add the name to the database:
PHP Code:
<?php require_once('../Connections/conn.php'); ?>
// filename: upload.php 

// first let's set some variables 

// make a note of the current working directory, relative to root. 
$directory_self str_replace(basename($_SERVER['PHP_SELF']), ''$_SERVER['PHP_SELF']); 

// make a note of the directory that will recieve the uploaded file 
$uploadsDirectory $_SERVER['DOCUMENT_ROOT'] . $directory_self '../images/'

// make a note of the location of the upload form in case we need it 
$uploadForm 'http://' $_SERVER['HTTP_HOST'] . $directory_self 'index.php'

// make a note of the location of the success page 
$uploadSuccess 'http://' $_SERVER['HTTP_HOST'] . $directory_self 'success.php'

// fieldname used within the file <input> of the HTML form 
$fieldname 'file'

// Now let's deal with the upload 

// possible PHP upload errors 
$errors = array(=> 'php.ini max file size exceeded'
=> 'html form max file size exceeded'
=> 'file upload was only partial'
=> 'no file was attached'); 

// check the upload form was actually submitted else print the form 
error('the upload form is neaded'$uploadForm); 

// check for PHP's built-in uploading errors 
($_FILES[$fieldname]['error'] == 0
error($errors[$_FILES[$fieldname]['error']], $uploadForm); 
// check that the file we are working on really was the subject of an HTTP upload 
error('not an HTTP upload'$uploadForm); 
// validation... since this is an image upload script we should run a check   
// to make sure the uploaded file is in fact an image. Here is a simple check: 
// getimagesize() returns false if the file tested is not an image. 
error('only image uploads are allowed'$uploadForm); 
// make a unique filename for the uploaded file and check it is not already 
// taken... if it is already taken keep trying until we find a vacant one 
// sample filename: 1140732936-filename.jpg 
$uploadFilename $uploadsDirectory.$_FILES[$fieldname]['name'];

// now let's move the file to its final location and allocate the new filename to it 
@move_uploaded_file($_FILES[$fieldname]['tmp_name'], $uploadFilename
error('receiving directory insuffiecient permission'$uploadForm); 
header('Location: ' $uploadSuccess);
// The following function is an error handler which is used 
// to output an HTML error page if the file upload fails 
function error($error$location$seconds 5

'<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"'."\n"
'<html lang="en">'."\n"
'    <head>'."\n"
'        <meta http-equiv="content-type" content="text/html; charset=iso-8859-1">'."\n\n"
'        <link rel="stylesheet" type="text/css" href="stylesheet.css">'."\n\n"
'    <title>Upload error</title>'."\n\n"
'    </head>'."\n\n"
'    <body>'."\n\n"
'    <div id="Upload">'."\n\n"
'        <h1>Upload failure</h1>'."\n\n"
'        <p>An error has occured: '."\n\n"
'        <span class="red">' $error '...</span>'."\n\n"
'         The upload form is reloading</p>'."\n\n"
'     </div>'."\n\n"
// end error handler 

Now, all I want to do is add $uploadFilename to my my database table 'home'. Anyone out there help me out?

Thanks for any help!