upload script

<?php

require_once 'mysql.php';

	$result = mysql_query("SELECT * FROM Songs");
	$num_rows = mysql_num_rows($result);
	


	$error = 0;
	

	$songnumber = $num_rows +=1;
	
$songname = '';

if ((($_FILES["file"]["type"] == "audio/mp3") || ($_FILES["file"]["type"] == "audio/mp3")) && ($_FILES["file"]["size"] < 21000000))
  {
  if ($_FILES["file"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
    }
  else
    {
    echo "";//another echo to display after upload is complete
 
 $query1 = mysql_query("SELECT * FROM Songs WHERE Songname = '". $_FILES["files"]["name"] .""); 
 
 if($query1 != '') {
	$error +=1;
 }
 
    if (file_exists("../songs/" . $_FILES["file"]["name"]) || $error !=0)
      {
      echo $_FILES["file"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file"]["tmp_name"],
      "../songs/" . $_FILES["file"]["name"]);
//Below shows the link for the mp3

	$songname = $_FILES["file"]["name"];

	mysql_query("INSERT INTO Songs (Songname, Songnumber) VALUES ('$songname', '$songnumber')");
	
      echo "Your song has been uploaded <a href=\"../index.php\">Click here</a> to go back";
      }
    }
  }
else
  {
  echo "Extension not allowed"; //Error message here if it's to big or wrong extension
  }
?>