i am going to be using a php graphing library called phpgraphlib (http://www.ebrueggeman.com/phpgraphlib/
) and need to create an array with with data in it that i drawing from my database.
an example query will draw the number of times an event occurs on a range of days, for example:
SELECT date, count FROM calllog WHERE (date BETWEEN '$startdate' AND '$enddate') AND (company_id = '$companyid') ORDER BY date, company_id ASC
the array i need created from this query needs to look like this:
$resuts = array("12/2/10"=>99, "13/2/10"=>98, "14//2/10"=>70, "15/2/10"=>90);
thanks for the help, i hope that is clear!