What's wrong in this file upload script (below) ?

[jd2007]

<?php

include("connect.php");
if ($_FILES["file"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
    }
  else
    {
    echo "Upload: " . $_FILES["file"]["name"] . "<br />";
    echo "Type: " . $_FILES["file"]["type"] . "<br />";
    echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
    echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";

    if (file_exists("upload/" . $_FILES["file"]["name"]))
      {
      echo $_FILES["file"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file"]["tmp_name"],
      "upload/" . $_FILES["file"]["name"]);
      echo "Stored in: " . "upload/" . $_FILES["file"]["name"];
      $songt=$_GET[u]."songs";      
$query="insert into $songt(name, artist) values ($_POST[name], $_POST[artist])";
$result=mysql_query($query);

      }
    }
     
?>

 

i get output:

 

Return Code 1...

 

i file i try to upload is C:\Documents and Settings\oem\My Documents\My Music\Train-Drops_of_Jupiter.mp3

[Fadion]

I dont get this query:

$query="insert into $songt(name, artist) values ($_POST[name], $_POST[artist])";

 

Shouldnt it be:

$query="insert into table (name, artist) values ('{$_POST['name']}', '{$_POST['artist'])}'";