Thank you very much my friend. The significant difference between your code and mine is that my file contents are going into a MySQL database and it is this db function that is crapping out. The SQL (with variables replaced with static values) runs clean -> http://pastie.org/4302489 But as soon as you throw in a variable/dynamic value, it just becomes a mess. Brad -----Original Message----- From: Jim Giner [mailto:jim.giner@xxxxxxxxxxxxxxxxxx] Sent: Tuesday, July 24, 2012 8:45 AM To: php-db@xxxxxxxxxxxxx Subject: Re: Stuck trying to upload and grab file name At the risk of being unable to understand all the posts that are here already, here is some std. code that I use when I'm uploading a file. First - i capture the input field in a local var and all of its components in other local vars to make my coding easier later on. $inputfield = $_POST['infile']; // infile is the html name of the type='file' field $destfolder = (where I want the end result stored) $outfile = (the filename of the end result) $result = HandleUploadedFile($inputfield,$destfolder,$outfile); (handle $result after return) ******* The function I use: function HandleUploadedFile($inputfield,$destfolder,$outfile) { // parm 1 is the name of the type=file field in the html; 2 & 3 are path and output filename you want to store it in global $msg,$ftype,$ferror,$fname,$fsize,$ftmpname; $ftype = $_FILES[$inputfield]["type"]; $ferror = $_FILES[$inputfield]["error"]; $fname = $_FILES[$inputfield]["name"]; $fsize = $_FILES[$inputfield]["size"]; $ftmpname = $_FILES[$inputfield]["tmp_name"]; // code up acceptabe filetypes here if ( $ftype == "text/plain") { if ($ferror > 0) { $msg .= ' Upload error - return code was '.$ferror; return False; } else { if (file_exists($destfolder . $fname)) { $msg .= " Duplicate filename - upload not done, continuing."; return True; } else { $msg .= " File has been uploaded to: " . $destfolder .$outfile; move_uploaded_file($ftmpname,$destfolder . $outfile); return True; } } } else { $msg .= " Invalid file type for menu input upload"; $msg .= " Type is ".$ftype; return False; } } You of course want to name your end result like the original filename, so you will have to make a change to that parameter, but this will work for you. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php