Re: graph - dowloads/hr

Richard Lynch wrote:

On Tue, August 9, 2005 3:07 pm, Sebastian wrote:

i'd like to create a graph with the amount of downloads per hour, i am a little confused how i should go about this. i know i can use rrdtool/mrtg, but im looking for more 'user friendly' graphs with custom colors,etc. each time someone downloads a file it is incremented in the db and the last time the file was downloaded. i am unsure about the data i would need to store to create and if what i am storing is enough to do this. any suggestions or tools that already exists to create this types of graph?

select count(*) as score from downloads where date_add(download_time, interval 1 hour) >= now() group by filename order by score desc Then you use jpgraph on that result set. Or just roll your own with http://php.net/gd

Richard, the last download time is store in unix timestamp.. is it possible to still do it? thanks. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.6/69 - Release Date: 8/11/2005