Hey, where making a site for a made-up library at school and though my teachers is really nice she isn't helping at all. So for all the people out there, can you find whats wrong with it; cause it starting to really irritate me. Cheers.
<?php
$Author = $_POST[Author];
$Title = $_POST[Title];
$Genre = $_POST[Genre];
$BookBarcode = $_POST[BookBarcode];
$CallNo = $_POST[CallNum];
$ISBN = $_POST[ISBN];
$Copies = $_POST[Copies];
$BookDetails = $_POST[BookDetails];
mysql_connect("localhost","USERNAME","PASSWORD") or die(mysql_error());
mysql_select_db("DATABASE NAME") or die(mysql_error());
$query=mysql_query("INSERT INTO bookdetails (Author, Title, Genre, BookBarcode, CallNum, ISBN, Copies, BookDetails) VALUES ('$Author', '$Title', '$Genre', '$BookBarcode', '$CallNo', '$ISBN', '$Copies', '$BookDetails')") or die(mysql_error());
?>
<html>
<head>
<title>PHP New book</title>
<body text="Black" link="white" vlink="white" alink="white" bgcolor="0188BF"/>
</head>
<center>
<img src="TinyTown Logo.bmp" align="center" hspace="2" vspace="2" width="185" height="41" alt="TinyTown Logo"/>
<body>
<!-Hyperlinks are located at the base of the logo->
<br>
<center>
<br>
<a href="Main Menu.html">MAIN MENU</a> •
<a href="Members.html">MEMBERS</a> •
<a href="Reservations.html">RESERVATIONS</a> •
<a href="Overdues.html">OVERDUE</a> •
<a href="Leading.html">LEADING</a>
<br>
<br>
<hr width="75%">
</center>
</body>
<!-START OF SITES BODY->
<body>
<center>
<p><b><p style="font-size: 18pt"><font color="white"><font face="Copperplate Gothic Bold">New Book Added</font></b></p>
<br>
<br>
<centre>
<a href="Catalogue.html">Back to Catalogue Menu</a><br>
<a href="Main Menu.html">Back to Main Menu</a>
</centre>
</body>
</centre>
</html>
<?php
$Author = $_POST[Author];
$Title = $_POST[Title];
$Genre = $_POST[Genre];
$BookBarcode = $_POST[BookBarcode];
$CallNo = $_POST[CallNum];
$ISBN = $_POST[ISBN];
$Copies = $_POST[Copies];
$BookDetails = $_POST[BookDetails];
mysql_connect("localhost","USERNAME","PASSWORD") or die(mysql_error());
mysql_select_db("DATABASE NAME") or die(mysql_error());
$query=mysql_query("INSERT INTO bookdetails (Author, Title, Genre, BookBarcode, CallNum, ISBN, Copies, BookDetails) VALUES ('$Author', '$Title', '$Genre', '$BookBarcode', '$CallNo', '$ISBN', '$Copies', '$BookDetails')") or die(mysql_error());
?>
<html>
<head>
<title>PHP New book</title>
<body text="Black" link="white" vlink="white" alink="white" bgcolor="0188BF"/>
</head>
<center>
<img src="TinyTown Logo.bmp" align="center" hspace="2" vspace="2" width="185" height="41" alt="TinyTown Logo"/>
<body>
<!-Hyperlinks are located at the base of the logo->
<br>
<center>
<br>
<a href="Main Menu.html">MAIN MENU</a> •
<a href="Members.html">MEMBERS</a> •
<a href="Reservations.html">RESERVATIONS</a> •
<a href="Overdues.html">OVERDUE</a> •
<a href="Leading.html">LEADING</a>
<br>
<br>
<hr width="75%">
</center>
</body>
<!-START OF SITES BODY->
<body>
<center>
<p><b><p style="font-size: 18pt"><font color="white"><font face="Copperplate Gothic Bold">New Book Added</font></b></p>
<br>
<br>
<centre>
<a href="Catalogue.html">Back to Catalogue Menu</a><br>
<a href="Main Menu.html">Back to Main Menu</a>
</centre>
</body>
</centre>
</html>