My first post here, hoping someone could throw some pointers my way, I really doubt the problems too complicated for you hehe

So I've just started experimenting in php and mysql, and am attempting to write information taken from a form, to a database. Ill be damned if I can get it to work, I cant escape the evil clutches of this error message: 'Parse error: parse error, unexpected T_VARIABLE in C:\xampplite\phpMyAdmin\customer\addcustomer.php on line 10'. From what I can gather, this is on the query line. Any pointers would be hugely appreciated, thanks for your time people.
Code: Select all
<?php
include "connection.php"
?>
<?php
$newFirstname = $_POST['firstname']
$newSurname = $_POST['surname']
$newUsername = $_POST['username']
$newEmail = $_POST['email']
$newPassword = $_POST['password']
$query = "INSERT INTO Customer (Firstnames, Surname, Username, Email, Password) VALUES ('$newFirstname', '$newSurname', '$newUsername', '$newEmail', '$newPassword')";
$result = mysql_query($query) or die ("Error in query:$query.
".mysql_error());
echo "New Record Inserted!";
mysql_close($connection);
?>