Code: Select all
Could not insert data because 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 's)' at line 1Any suggestions?
Moderator: General Moderators
Code: Select all
Could not insert data because 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 's)' at line 1Code: Select all
//if not insert data
if ($error == "none") {
$insert = mysql_query("insert into users values ('$username', '$pass2', '$fname', '$phone', '$Email', '$address', '$city', '$state', '$zip', '$country', '$ip', '$date's)")
or die("Could not insert data because ".mysql_error());
echo '<center><font color="#ff0000"><h4>Thank You, Your Account Has Been Created</h4>';
if ($error == "none") {
echo '<meta http-equiv="refresh" content="3;url=login.php">';
exit;
}
}Code: Select all
'$date's)") Hehe, never noticed how many keywords SQL has.thefreebielife wrote:Code: Select all
Could not insert data because 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 's)' at line 1