[SOLVED] selecting dates from database

[timmah1]

I need to select everything from the database of the current month

the field in the database is orderDate (0000-00-00)

 

What I have does not grab anything, it just says no sales, when I know there are at least 3 in there

$month = date("m");

	$sql = "SELECT * FROM memSales WHERE orderDate = '$month'";
	$q = mysql_query($sql);	
	$numrows = mysql_num_rows($q);

		if($numrows == 0) {
			echo "No sales for $month<br>";
			echo "<a href='javascript: history.go(-1)'>Go Back</a>";
		}

	while($a = mysql_fetch_assoc($q)){	

		echo $a['orderDate']."-".$a['price'];;
}

 

Anybody have any ideas?

 

Thanks in advance

[PFMaBiSmAd]

 

 

The current month also includes the current year. Otherwise a year or more from now, you will get data for more than one year.

 

$sql = "SELECT * FROM memSales WHERE EXTRACT(YEAR_MONTH FROM orderDate) = EXTRACT(YEAR_MONTH FROM CURDATE())";

[timmah1]

Thank you very much