posted 07-10-2008 10:30 PM                       

quote:

---

include('config.php');

//Connect to database
$cxn = mysqli_connect($host, $username, $password, ********) or die ("No connection can be made.");

//Get the parent's ID number from URL.
$fID = $_GET['fID'];
//Get the variables from our modFile form.
$title=$_POST['title'];
$desc=$_POST['desc'];
$fGenre=$_POST['fGenre'];
//Get the user's name for proper credit.
$userName=$_SESSION['name'];

// Get the file name and add "m" for MOD file.
$file_name = $_FILES['modFile']['name'];
$uploadLetter=m;

// Random 7 digit number to add to our file name
$random_digit=rand(0000000000,9999999999);

//Here's how we create the new file name.
$new_file_name=$uploadLetter.$random_digit.$file_name;

//set where you want to store files
$path= "files/fileUploads/mods/".$new_file_name;

if($modFile !=none)
{

if(move_uploaded_file($_FILES['modFile']['tmp_name'], $path))
{
echo "Successful<BR/>";

echo "File Name :".$new_file_name."<BR/>";
echo "File Size :".$_FILES['modFile']['size']."<BR/>";
echo "File Type :".$_FILES['modFile']['type']."<BR/>";
}

else
{
echo "Error";
}
}


mysqli_query($cxn, "INSERT INTO fileAlt (parent, fileName, desc, fileGenre, uploader, filePath) VALUES ('$fID', '$title', '$desc', '$fGenre', '$userName', '$path')") or die ('FAILED.');

---

posted 07-10-2008 11:05 PM                       

quote:

---

Successful
File Name :m669703611Triple-star_sunset.jpg
File Size :46390
File Type :image/jpeg
INSERT INTO fileAlt (parent, fileName, desc, fileGenre, uploader, filePath) VALUES ('1', 'test', 'test', 'test', '', 'files/fileUploads/mods/m669703611Triple-star_sunset.jpg')

---

quote:

---

Error

SQL query:

INSERT INTO fileAlt( parent, fileName, DESC , fileGenre, uploader, filePath )
VALUES (
'1', 'test', 'test', 'test', '', 'files/fileUploads/mods/m669703611Triple-star_sunset.jpg'
)

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc, fileGenre, uploader, filePath) VALUES ('1', 'test', 'test', 'test', '', 'f' at line 1

---