<?PHP
require('dblink.php');
//mysql query
$query = 'INSERT INTO member (username("'.$_POST[username].'"), password("'.$_POST[password].'"), email1("'.$_POST[email1].'"), firstname("'.$_POST[firstname].'"), lastname("'.$_POST[lastname].'"), sex("'.$_POST[sex].'"), dob("'.$_POST[dob].'"), city("'.$_POST[city].'"), country("'.$_POST[country].'"))';
mysql_query($query)
or die(mysql_error());
$db_query = mysql_query($query);
$to = $_POST['email1'];//the email address the user submitted
$subject = 'You Registered!';
$message = 'You have just registered to play on The Streets. To log in go to the main page and use your username and password to sign in.'//the body of the email you are sending
break;
Username: $_POST['username']
break;
Password: $_POST['password'];
mail($to, $subject, $message);//mail sent
?>
it says the parse error is on line 14 which is
$to = $_POST['email1'];//the email address the user submitted
$query = 'INSERT INTO member (username("'.$_POST[username].'"), password("'.$_POST[password].'"), email1("'.$_POST[email1].'"), firstname("'.$_POST[firstname].'"), lastname("'.$_POST[lastname].'"), sex("'.$_POST[sex].'"), dob("'.$_POST[dob].'"), city("'.$_POST[city].'"), country("'.$_POST[country].'"))';
here is the error message
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '("admin"), password("test"), email1("methodman14@hotmail.com"),
the username i typed in was admin the password was test and the email was methodman14