In the final echo statement I am trying to insert the information from the form field $POST['first_name'] in the following sentence. "Thank you $POST['first_name'], please log in now". But I keep getting a parse error. What am I doing wrong?
$sql = "INSERT INTO USERS (first_name, last_name, email_address, username, password, signup_date)
VALUES('$first_name', '$last_name', '$email_address', '$username', '$password', NOW())";
@mysql_query($sql) or die(mysql_error().'<p>'.$sql.'</p>');
if (mysql_affected_rows() < 1) {
echo 'There has been an error creating your account. Please contact the webmaster.';
}
else
{
echo
'<div align="center">
<p> </p>
<p> </p>
<p> </p>
<p><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Successfully submitted, please <a href="bd_login.php"><font color="#FFFF00">login </font></a>now.</strong></font></p>
<p> </p>
<p> </p>
<p> </p>
</div>';
}
}
}
?>