Inserting Date into database

[Cyberspace]

Im trying to add the current date in a mysql database, but im not sure if im on the right track:

 

Im using the following sql insert statement:

 

   mysql_query("INSERT INTO walker (MemberRef, WalkNo, DateJoined) VALUES ('$MemberRef', '$WalkNo', NOW()");  

 

 

Can i use date(Now) to insert the current date?

[rhodesa]

mysql_query("INSERT INTO walker (MemberRef, WalkNo, DateJoined) VALUES ('$MemberRef', '$WalkNo',NOW())");  

 

Assuming DateJoined is one of the Date datatypes

[discomatt]

If DateJoined is a datetime type column, the query you posted should work fine

[benphp]

nevermind

 

 

[Cyberspace]

mysql_query("INSERT INTO walker (MemberRef, WalkNo, DateJoined) VALUES ('$MemberRef', '$WalkNo',NOW())");  

 

Assuming DateJoined is one of the Date datatypes

 

Thanks for that