Inserting date into database

**Xmen** · 09-12-2009

Hi
I am trying a simple example in php. I have designed a form, when the user registers, I try to create their joining date.

Code:

CREATE TABLE Users
(
	usrnm varchar(15) NOT NULL,
	regdate datetime default NULL
)

then the sql gets that value

Code:

$sql = "INSERT INTO Users (usrnm, regdate)
VALUES ('".$usrnm."' , '".NOW()."')";

The error I am getting is

Code:

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING

I think this is because I may have created a wrong syntax. Please help. Any advice on this.

**Reegan** · 09-12-2009

Hi
You have done a small mistake in your syntax forming, you have

$sql = "INSERT INTO Users (usrnm, regdate)
VALUES ('".$usrnm."' , '".NOW()."')";

It should be

Code:

$sql = "INSERT INTO `Users` (`usrnm`, `regdate`)
VALUES ('" . $usrnm . "', NOW())";

Please correct the mistake.

**Xmen** · 09-12-2009

Hi
I am blind, sorry for the mistake. I have corrected this but the error is still there. This is how I have modified it

Code:

$sql = "INSERT INTO Users (usnm, firstName, lastName, emailaddress, password, passwordsalt, registrationIP, regdate)
VALUES ('".$usrnm."' , '".$firstname."' , '".$lastname."' , '".$emailaddress"' , '".$passhash."' , '".$salt."' , '".$registrationip."' , NOW())";

As you said, the "NOW()" is right at the end. Any advice on this.

**Reegan** · 09-12-2009

Hi

Code:

$sql = "INSERT INTO Users (usnm, firstName, lastName, emailaddress, password, passwordsalt, registrationIP, regdate)
VALUES ('".$usrnm."' , '".$firstname."' , '".$lastname."' , '".$emailaddress"' , '".$passhash."' , '".$salt."' , '".$registrationip."' , NOW())";

This is you statement, you are missing something again, and even this time it is a simple mistake.

Code: