Needing help with the insert into command please.
Posted: Mon Oct 23, 2006 5:23 am
Hey guys,
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.
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);
?>