i have this query:
SELECT COUNT(*) AS score FROM downloads WHERE date_add(dateline,
interval 1 hour) >= now() GROUP BY filename ORDER BY score DESC
unfortunately for other reasons i had to change `dateline` to unix timestamp so this query
is no longer able to run as intended. can anyone help with a work around?
btw, i am using php to run queries if that helps find a solution.
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.9/72 - Release Date: 8/14/2005