can anyone please fix this script for me...it's not working.
<html>
<head>
<title>Post Books</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?
$name=$POST['name'];
$email=$POST['email'];
$phone=$POST['phone'];
$title=$POST['title'];
$author=$POST['author'];
$isbn=$POST['isbn'];
$university=$POST['university'];
$condition=$POST['condition'];
$price=$_POST['price'];
$location="localhost";
$username="username";
$password="password";
$database="mydatabase";
$conn = mysql_connect("$location","$username","$password");
if (!$conn) die ("Could not connect MySQL");
mysql_select_db($database,$conn) or die ("Could not open database");
$query = "INSERT INTO books(name,email,phone,title,author,isbn,university,condition,price VALUES('','$name','$email','
phone','title','author','isbn','university','condition','price',())";
$result=mysql_query($query);
$echo"You Textbook and Contact Info Have Been Posted to Bookzella.com Database!<br><br>Thank You.\n";
mysql_close();
</body>
</html>
?>
