Best sellers - timed

[blarney]

I am trying to create a similar situation (ZC v1.3.8a) but where the best sellers automatically pulls only the records from the most recent 30 days. I know just enough PHP to be dangerous but figure with some help, maybe this can get sorted out and benefit others as well. I"m working in the /includes/modules/[customtemplate]/best_sellers_reloaded.php (same code as in the best seller sidebox). Here's what I have:

Near the top of the page I defined my one month time like this:

$lastmonth = mktime(0, 0, 0, date("m"), date("d")-30, date("y"));

I modified the query as follows:

$best_sellers_query = "select distinct p.products_id, p.products_image, pd.products_name, p.products_ordered
from " . TABLE_ORDERS . ' o, ' . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
. TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c
where p.products_status = '1'
and p.products_ordered > 0
and p.products_id = pd.products_id
and p2c.products_id = p.products_id
and o.date_purchased => date('m/d/y', $lastmonth)
and p2c.categories_id = 2
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and p.products_quantity > 0
order by p.products_ordered desc, pd.products_name
limit " . MAX_DISPLAY_SEARCH_RESULTS_BEST_SELLERS;
}

I assume my problem is in the "date('m/d/y', $lastmonth)" but not sure how it should be. I tried Y-m-d H:i:s instead of m/d/y thinking it might recognize it but no joy. Tried with and w/o quotes too. An extra set of more experienced eyes would be appreciated. Thanks.

Jim

[blarney]

There was a typo in the string where I inverted the >= symbol. Supposed to be:

and o.date_purchased >= date('m/d/y', $lastmonth)

I also tried using

and o.date_purchased >= $lastmonth

without formating the $lastmonth variable but that was also unsuccessful.

Any suggestions? Thanks.

Jim