|
|
Posted by "Richard Lynch" on 08/11/05 00:05
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
Navigation:
[Reply to this message]
|