can you spot the not?

[ok]

what's wrong with these codes?

 

$query = "INSERT INTO user_join (user_name, email, invited_by, date_join) VALUES ('$ufull_name', '$uemail', '$rfull_name', 'now()'";
mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());

 

Thank you?

[pocobueno1388]

What's the error?

 

My guess to why it's not working is because you have the NOW() function in quotes. Also, your missing a parenthesis from the end.

 

So try this instead

$query = "INSERT INTO user_join (user_name, email, invited_by, date_join) VALUES ('$ufull_name', '$uemail', '$rfull_name', NOW())";

[cyrixware]

Wer did you get the now()? what if create a variable for the date() and pass the date() to the variable.... instead of now in your query change it to the variable you declared for the date. 

[pocobueno1388]

Wer did you get the now()? what if create a variable for the date() and pass the date() to the variable.... instead of now in your query change it to the variable you declared for the date. 

 

NOW() is a MySQL function that inserts the current date/time into a datetime field in the database. So they are using it perfectly fine, no need to declare a date variable.