Display product added/modified count in last 7 days in admin

[DigitalShadow]

I use this

$products_stock = $db->Execute("select sum(products_quantity) as count from " . TABLE_PRODUCTS);

to show current stock total, what I am after is a way to show what has has been added in the last 7 days.

so some kind of where statement would be needed i presume, I've tried working the code myself, but I can't figure it out, hence why I am asking.

Basically, I would like to be able to show how many products have been added or modified in the last 7 days and display that number in the admin.

Thank you in advance

[DigitalShadow]

In the catalog i have modified $new_range

$new_range = ' and (p.products_date_added >=' . $zc_new_date . ' or p.products_last_modified >=' . $zc_new_date . ')';

to show new and modified products

[DigitalShadow]

anyone?

[DigitalShadow]

<?php
 $products_added = $db->Execute("select count(*) as count, products_date_added, products_last_modified from " . TABLE_PRODUCTS . " where products_date_added >= DATE_SUB(CURDATE(), INTERVAL 1 WEEK) or products_last_modified >= DATE_SUB(CURDATE(), INTERVAL 1 WEEK)");
    echo '<span>Current Stock Total: ' . $products_added->fields['count'] . '</span>';
?>