I am building a game website and I am working on my user registration form. Everything was working fine until I tried to add a function to include the registration date. The form is processed and it looks like it has registered the user, but there is no entry placed into the database.
$join = date('Y-m-d');
mysql_query("INSERT INTO users (user_name, user_login, user_pw, user_email, user_bmonth, user_bday, user_byear, user_sex, join)
VALUES ('$name', '$login', '$pass', '$em', '$_POST[bmonth]', '$_POST[bday]', '$_POST[byear]', '$_POST[sex]', '$join')");
The "join" field type is set to DATE.
What am I doing wrong?
Thanks