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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
