Parse Error on my script.

[biohazard35]

I'm just now learning how to do PHP and I'm having trouble with a script I'm making. The script is:

 

<?php
$username="username";
$password="password";
$database="database";

$CoordX=$_POST['CoordX'];
$CoordY=$_POST['CoordY'];
$TypePlane=$_POST['TypePlane'];
$Area=$_POST['Area'];

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO tablename VALUES
('','$CoordX','$CoordY','$TypePlane','$Area');

mysql_query($query);

mysql_close();
?>

 

When ever I try to submit the form that goes with it I get this error:

 

Parse error: syntax error, unexpected $end in /home/zacsblog/public_html/insert.php on line 29

 

What is the problem?? Please help. Line 29 is the very end of the script.

[MockY]

Replace

$query = "INSERT INTO tablename VALUES
('','$CoordX','$CoordY','$TypePlane','$Area');

with

$query = "INSERT INTO tablename VALUES
('','$CoordX','$CoordY','$TypePlane','$Area')";

You are missing closing "

[Pikachu2000]

You were missing the closing quote here:

 

VALUES ('','$CoordX','$CoordY','$TypePlane','$Area')";

[biohazard35]

Thanks!