values wont get inserted why?

[xcoderx]

whats wrong in here for i get query failed everytime i submit the form?

 

//Create INSERT query
$qry = "INSERT INTO class_members (user_name, passwrd, f_name, l_name, email, gender, date) VALUES('$user_name','".md5($_POST['password'])."','$f_name','$l_name','$email', '$gender','gmdate($date)',)";
$result = @mysql_query($qry);

//Check whether the query was successful or not
if($result) {
	header("location: register-success.php");
	exit();
}else {
	die("Query failed");
}

[Adam]

You have an extra comma at the end:

 

(...) gmdate($date)',)";

 

mysql_error would have probably altered you to that.

[xcoderx]

lol fixed. thanks soo much bro :-0, now the date and time not being inserted in database. its all 00000000

[Adam]

No worries!

[PFMaBiSmAd]

gmdate() is a php function. You cannot put it inside a php string. When put inside of a string, your code is the characters 'g','m','d','a','t','e','(','$,'d','a','t','e',')'.

[xcoderx]

what must i use then so that i get the users registration date and time?

[PFMaBiSmAd]

You cannot put it inside a php string.

 

Doesn't that suggest to you that you should put it on the outside of a php string?

[xcoderx]

oops sorry didn read it well. yes outside of strings let me try

[xcoderx]

now() did the job thanks guys.