[RESOLVED] error

[sara123]

I am now recieving the following error and not sure what it means:

Error, query failed : Unknown column 'name' in 'field list'

below is the query I am using:

$query = "INSERT INTO upload2 (name, size, type, path ) ".
"VALUES ('$fileName', '$fileSize', '$fileType', '$filePath')";

I have checked the names in my table and the all match, so not sure whats wrong.

[laserlight]

What is the full error message, and what database management system are you using?

[sara123]

that is the full message I am getting. I have used phpmyadmin for my database:

Error, query failed : Unknown column 'name' in 'field list'

below is my php code.

$uploadDir = '/home/vol3/aa/public_html/project/upload/';

if(isset($POST['upload']))
{
$fileName = $FILES['userfile']['name'];
$tmpName = $FILES['userfile']['tmp_name'];
$fileSize = $FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];

$filePath = $uploadDir . $fileName;

$result = move_uploaded_file($tmpName, $filePath);
if (!$result) {
echo "Error uploading file";
exit;
}

if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
$filePath = addslashes($filePath);
}

$query = "INSERT INTO upload2 (name, size, type, path ) ".
"VALUES ('$fileName', '$fileSize', '$fileType', '$filePath')";

mysql_query($query) or die('Error, query failed : ' . mysql_error());

echo "<br>Files uploaded<br>";

}
?>