[SOLVED] Grab info based on month

[timmah1]

I'm trying to break down sales on a monthly basis.

I want to show information for each month.

 

So, right now I'm trying to grab everything from the database where the field 'purchase'(month) equals May (05)

The purchase field type is DATE

 

Here is what I have, and it is not working correctly

$month = "05";
$sql3 = "SELECT * FROM affiliates1 WHERE purchase = '".date("m", strtotime($month))."' AND affil_id = '$code'";

 

How can I accomplish this?

 

Thanks in advance

[the182guy]

If you're using MySQL you can use the MySQL function DATE_FORMAT() to achieve the desired results.

 

For example,

 

$month = "05";
$sql3 = "SELECT * FROM affiliates1 WHERE DATE_FORMAT(purchase, '%m') = '$month' AND affil_id = '$code'";

[timmah1]

Perfect!

Thank you 182