Insert Date in MySQL Problem

[Redlightpacket]

Some how the line below will not work.

I'm trying to make the current date input into the database when I insert data into the database.

 

 

$query = "CREATE TABLE IF NOT EXISTS _0_calendar_data(id SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY, news TEXT(1200),  date INT(30), date2 INT(30))";

 

 

//The one right here needs attention

$result = "INSERT INTO _0_calendar_data(id, news, date, date2) VALUES (NULL, '$news', 'YEAR: Auto CURDATE()', CURDATE())";

[fenway]

You can't store dates as INTs and use CURDATE() -- not to mention strings.