I would like to have some bar charts created from the data in the attachment. What I would like is 1 page with multiple bar charts that updates realtime, meaning it grabs teh data out of the DB every time to create the charts.
I would like a chart for fields:
3 - Seasons
4 - Month
5 - Time of day (morning afternoon, etc)
6 - Time of day by hr.
7 - Height in inches
8 - weight in lbs
9 - Color
10 - width
11 - length
With each chart I would also like a line that says how many records were used to create the chart. Not every record has an entry for each field.
You may use a 3rd party solutions as long is it is free (no licenced or pay 3rd party apps) and is in PHP.
Here is the dump of the db table:
CREATE TABLE datapoints (
id int(8) NOT NULL auto_increment,
record int(8) NOT NULL default '0',
season varchar(20) NOT NULL default '',
month varchar(20) NOT NULL default '',
tofday varchar(10) NOT NULL default '',
stimes varchar(7) NOT NULL default '',
height varchar(10) NOT NULL default '',
weight varchar(10) NOT NULL default '',
color varchar(20) NOT NULL default '',
twidth varchar(10) NOT NULL default '',
tlength varchar(10) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
Please contact me if you have any more questions.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
## Platform
Linux server running php and Mysql. ALso have GD LIB.