Need help with DATE_SUB query

I would like to return results for month to date.

I tried the query below, but it doesn't work. Can someone help me?

SELECT * FROM myTable WHERE DATE_SUB(CURDATE(), INTERVAL (DAYOFMONTH(CURDATE())) DAY <= timestamp;

I am sure that I have the syntax wrong, but would like to see if someone can help here.

Thanks.

Are you getting an error message?

Make sure you error check using

mysql_query($query) or die ("Error in Query " mysql_error());

What results ARE you getting?

Well,

SELECT * FROM myTable WHERE DATE_SUB(CURDATE(), INTERVAL (DAYOFMONTH(CURDATE())) DAY <= timestamp;

generates:

ERROR 1064: You have an error in your SQL syntax near '<= timestamp' at line 1

And:

SELECT * FROM myTable WHERE DATE_SUB(CURDATE(), INTERVAL DAYOFMONTH(CURDATE()) DAY;

generates:

ERROR 1064: You have an error in your SQL syntax near '' at line 1

Misplaced close paren ") DAY" should be "DAY )":

 SELECT * FROM myTable WHERE DATE_SUB(CURDATE(), INTERVAL (DAYOFMONTH(CURDATE()) DAY  )  <= timestamp;