Any help would be great
HERES THE CODE:
<html>
<title></title>
<head>
</head>
<body>
<?php
//connect to mysql database
require ($_SERVER["DOCUMENT_ROOT"]."/Config/music.php");
$connection = mysql_connect($db_host, $db_user, $db_pw) or die(mysql_error());
mysql_select_db($db_name, $connection);
?>
<!-- Add Song Form -->
<form action="<?php $_SERVER[PHP_SELF] ?>" method=post>
<input type="text" name="artist" maxlength="75" value="artist">
<input type="text" name="song" maxlength="75" value="song">
<input type="text" name="rating" maxlength="3" size="1">
<input type="text" name="albumID" maxlength="4" size="1" value="ID">
<input type="submit" name="submit" value="send">
</form><br>
<!-- end of form -->
<?php
$sql = "INSERT INTO songs values('','$_POST[artist]','$_POST[song]', $_POST[rating], $_POST[albumID])"
if (MYSQL_QUERY($sql, $connection)){ echo "Record Added!";}
?>
</body>
</html>
