[SOLVED] Setting curdate() as a variable

[poleposters]

Hi.

 

I want users to select a date for an entry. However if they fail to select a date, I want to insert the current date as default into the database.

 

Heres my code.

if(!empty($_POST['item_date']))
		{
		$item_date=$_POST['item_date'];
		}
		else
		{
		$item_date="CURDATE()";
		}

 

It doesn't want to work. It sets the date to to 1970 instead.

 

Can someone shed some light on what I'm doing wrong? Thanks/.

 

[Adam]

I assume the "$item_date" var is then passed through a query? Could you show us the code?

[poleposters]

The query is as follows.

 

$query="INSERT INTO press_releases (press_release_id,press_release_title,press_release,press_release_date) VALUES ('','$title','$press_release','$item_date')";
			$result=mysql_query($query) or trigger_error("Query: $query\n<br />MySQL Error: " . mysql_error());

 

It works fine if I pick a date.

 

And the query executes if I leave the date field blank. It just doesn't insert curdate()

 

 

[poleposters]

I worked it out.

 

I should of been using php's date() function instead.