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 -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
