datetime format error

[daok]

I cant Insert data in my database when the data is : datetime format.

mysql:
name---------type
date_items datetime

code :
$sql = 'INSERT INTO market (id_items, price_items, date_items ) VALUES('.$id_w.', '.trim($price).', '.date("d-m-Y H:i:s").' )';

error:
Something is wrong in your syntax near of ' 2560, 08-06-2003 13:39:36 )'

What is my error?

[barand]

Try ... date('Y-m-d H:i:s') ...

[daok]

Doesn't work but I use timestamp and it work

[Syket]

$sql = "INSERT INTO market (id_items, price_items, date_items ) VALUES('".$id_w."', '".trim($price)."', '".date("d-m-Y H:i:s")."' )";

This should work.