Why Doesn't This Work?

[Dysan]

Hi. The following code, is my attempt of uploading an MP3 file to the server, and then storing the path of the file inside a database. Why doesn't the line of code shown in bold work?

if (($_FILES["file"]["type"] == "audio/mpeg3"))
{
  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"];

  $sql="INSERT INTO Music (Path)
  VALUES
[B]      ('"upload/" . $_FILES["file"]["name"]')";[/B]
    }
  }
}
else
{
  echo "Invalid file";
}

[fuzzy1]

What is the structure (field names) of the table 'Music'?

[mpb001]

It is a quotes/concatenation issue..

$sql="INSERT INTO Music (Path)
      VALUES
      ( 'upload/" . $_FILES["file"]["name"] . "' )";