Sebastian <[EMAIL PROTECTED]> wrote on 08/15/2005 03:51:05 PM: > 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 >
One possible solution permutation... SELECT count(*) FROM downloads where dateline > UNIX_TIMESTAMP(now()) - 3600; Shawn Green Database Administrator Unimin Corporation - Spruce Pine
