date() and db question ?

[Pellefant]

Hello!

Sorry for asking here again... :rolleyes: Have searched the net and manual about this problem. I am not sure if the problem is with the date() or the database.

I do have

     

$datum = date("YY-mm-jj");                       

$Query = "INSERT INTO reviews(datum, type,artist,title,rating,coverlink,author,authoremail,reviewtext,link1,link2,approved,clicks) values ('$datum', '$typ',  '$artist', '$title', '$rating', '$coverlink', '$author', '$authoremail', '$reviewtext', '$link1', '$link2', '0','0')" or die (mysql_error());

Works fine 🙂 , but the "datum" put the databse always is: 0000-00-00. The database type of datum is "Date"

Thankful for any help.

[drew010]

The output of that date command is "20032003-0404-1818" on april 18 2003, only include the Y-m-j once. see http://www.php.net/date for usage.

[Pellefant]

Originally posted by drew010
The output of that date command is "20032003-0404-1818" on april 18 2003, only include the Y-m-j once. see http://www.php.net/date for usage.

That did the trick, thanks for the help drew010

🙂