[SOLVED] DATEPART Error

[marukochan]

Can someone tell me why my query for date part gives me an error

 

The code goes something like this

 

...
...
$month = $_POST['month'];
$query = mysql_query("SELECT * FROM project WHERE DATEPART(month, date_award)='$month'") or die(mysql_error());
...
....

 

The error is

Unknown column 'month' in 'where clause'

 

Do I need to include anything in order to use DATEPART.

 

Thanks

[thepip3r]

There is no DATEPART in MySQL...

http://forums.mysql.com/read.php?10,95045,95045#msg-95045

 

here are the valid date/time functions for MySQL:

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

[marukochan]

Really?! I must be reading the wrong tutorial. 

 

Thanks thepip3r.