multiple sort of query

[vaavi8r]

I have a database table that contains a field titled 'date', entered in the YYYY-MM-DD format.

I want to be able to select from that table ONLY the records entered within the past calendar month, not necessarily the last 30 days.

In other words, as of today (2003/12/05) it would only select records entered from 2003/12/01 to today. I want to run a otal of another column for these results.

I have tried this, but I cannot get it to sperate the month:

<?
$today = getdate(); 
$month = $today['mon']; 
$day = $today['mday'];
$year=$today['year'];


include("dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
mysql_select_db ("margaritaair_com"); 
$query = "SELECT SUM(hours) AS monthtotal FROM flightlog WHERE macid='MAC100' AND date ='$month';  

$result = mysql_query($query) or die(mysql_error());  

$row = mysql_fetch_assoc($result); 
mysql_close();
?> 

[Shrike]

$sql = "SELECT stuff FROM table WHERE MONTH(date) = ".date("m")." AND YEAR(date) = ".date("Y");

will select records where the month entry of date and year entry of date match todays month/year.

[Thora_Fan]

To expand on what Shrike posted,

http://www.mysql.com/doc/en/Date_and_time_functions.html

MySQL has a plethora of Time/Date functions. Very rarely do I use PHP Time/Date functions anymore, now that I found out the majority of it can be done in the SQL statement.