Daily attachments count query

[ericgtr]

Here is what I have but I don't think it's right, maybe someone can point me in the right direction as far as where I am pulling it from, it's hard to tell if dateline is correct.

// ### Total Daily Hits ##
$todays_views = $DB_site->query_first('
SELECT COUNT(*) AS count
FROM ' . TABLE_PREFIX . 'attachment
WHERE dateline >= "' . strtotime("-1day") . '"
');
$newhits = number_format($todays_views ['count']);
// ### Total Daily Hits ##