Using MySQL and PHP together with my Anti Virus Software program linked to a web database, I wish to create a system which is able to monitor the number of virus infections coming in over a certain period of time.
I wish to display the results using a series of different coloured boxes representing the different regions in which viruses are coming from.
For example, if so many viruses appear in a small space of time, then the colour of the box corresponding to the infected region will turn red. The other box colour variants I require are orange and then yellow for viruses which appear over a longer space of time.
I already have a query which can search for this information but it only returns the results in row format - Instead I wish to return the search results via coloured boxes.
For example, (where notification = the name of the database field responsible for alerting new viruses -
And boxcolour = certain region corresponding to the number of notifications received from a particular region)
if notification <= 300 & time <=30seconds then
boxcolour = red
if notification <= 100 & time <=120seconds then
boxcolour = orange
if notification <= 50 & time <=300seconds then
boxcolour = yellow
Any thing that you may think will be helpful would be much appreciated.
Please reply any ideas to al2k@talk21.com
