I have a quick and simple job. I need to generate data (query and pull data from an sql database) for online charts and graphs.
THE REQUIRED FORMAT
masterdate;webtotal;newstotal;blogtotal;disctotal
EXAMPLE 2011-01-20 10:42:26;482500;54465;4883;3995
I have attached a file that we have been working on but it is causing the following error:
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in
/home/content/t/r/a/trauch/html/XXXXX/[login to view URL] on line 21
You can find a sample and some instructions at [login to view URL]
DATABASE INFO:
$hostname='[login to view URL]';
$username='ihtribune';
$password='xxxxxxxx';
$dbname='ihtribune';
TABLE = "foodsafety"
webtotal text
newstotal text
blogtotal text
disctotal text
date timestamp