why doesn't this form work?

Anon

if I use the following, without the desc input field , the code works fine....however, as soon as i add the input field called desc, and change the SQL to insert desc into the database as well, it doesn't work...it comes up with my die message ('The requested table or database does not exist')... what am i doing wrong?

form code...

print "\n<form ENCTYPE=\"multipart/form-data\" action=\"" . $PHP_SELF . "\" method=\"post\">";
print "\n<INPUT TYPE=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"" . $my_max_file_size . "\">";
print "\n<INPUT TYPE=\"hidden\" name=\"task\" value=\"upload\">";
print "\n<P>Upload a file";
print "\n<BR>NOTE: Max file size is " . ($my_max_file_size / 1024) . "KB";
print "\n<br><INPUT NAME=\"the_file\" TYPE=\"file\" SIZE=\"35\"><br>";
print "\n<br><INPUT type=\"text\" name=\"filedesc\" SIZE=\"35\"><br>";

    print "\n<input type=\"submit\" Value=\"Upload\">";
    print "\n</form>";

sql code..

$query = "INSERT INTO filemanager (title, first, ext, date, desc) VALUES ('$title', '$first', '$ext', '$uploaddate', '$filedesc')";
$query_result_handle = mysql_query ($query)
or die ('The requested table or database does not exist');

Anon

I meant to say when I try to insert $filedesc into the database (not $desc), it fails...but if i take out the $filedesc input field and change the SQL statement, it works fine.

Anon

So is the field name desc in your table or filedesc?

KCK

Because DESC in mysql is a reserved word and I would not think anything you do using desc will work.

Anon

yeah, I changed the name from desc to filedesc, and now it doesn't come back with the error, but it doesn't insert the $filedesc variable into the filedesc field in the mySQL db.

Anon

What if you try the insert this way

$query = "INSERT INTO filemanager SET " .
"title='$title' , " .
"first='$first' , " .
"ext='$ext' , " .
"uploaddate='$uploaddate' , " .
"filedesc='$filedesc' ";

Anon

no, that doesn't work either....... i'm thinking maybe it has something to do with my HTML part of the code? it's driving me crazy