For this, my INSERT query looks like:
$sql = "INSERT INTO roster SET " . "first_name='$first', " . "last_name='$last', " . "email='$email', " . "password='$password', " . "join=CURDATE()";
But, when I submit the form, I get the error:
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 'join=CURDATE()' at line 1
What is wrong with my syntax, as I have another INSERT query that uses exactly the same thing.