ITFarmer
Posts: 1
|
| Posted: 01/31/2009, 2:51 PM |
|
When creating some flash graphs, I build an sql and check for the data. That seems to work, but when i publish the web-page the graph is empty.
Looks like when the code is generated by CodeCharge the SQL statements are not correctly used.
it is not an overly complicated query.
select sysdate,count(CellID)
from lightning
where sysdate >= date_sub(curdate(), interval 7 day)
group by sysdate
The output is:
2009-01-25 821
2009-01-26 296
2009-01-27 223
2009-01-28 140
2009-01-29 120
2009-01-30 142
2009-01-31 199
2009-02-01 62
But when I publish this (see flash chart on the right bottom corner) it shows empty.
http://www.lyndhurst-hill.info/last7days/index.php
Any suggestions?
Thanks
H.
|
 |
|
damian
Posts: 838
|
| Posted: 01/31/2009, 11:47 PM |
|
quite likely that your date format is different between your local/dev server and your live server.... try doing a phpinfo() and see what the servers date format is
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
|
 |
|
|
|
