|
|
|
Forum Newbie
Group: Forum Members
Last Login: 1/9/2008 9:04:43 AM
Posts: 2,
Visits: 3
|
|
| Hello, I am having difficulties using my mysql/php database with your charts. I just need a very simple (no drill down) example so I can start somewhere. Your "Basic" PHP DB example does not seem that simple to me and I keep getting either blank datasets or mysql errors. Can someone please generate a simple bar chart for the following query? Query = SELECT COUNT(evt_time_generated) as Count, evt_computer FROM eventlog.log_alerts group by evt_computer; This will get me a good starting point. Thanks, |
|
|
|
|
|
Supreme Being
Group: Moderators
Last Login: Today @ 5:38:52 AM
Posts: 884,
Visits: 1,420
|
|
| Hi, try this:
//Before this insert your code to connect to database (MySQL) = $link
$strQuery = "SELECT COUNT(evt_time_generated) as Count, evt_computer FROM eventlog.log_alerts group by evt_computer";
$result = mysql_query($strQuery) or die(mysql_error());
//generating XML for Chart
$strXML = "<graph>"; if ($result) {
while($ors = mysql_fetch_array($result)) {
$strXML .= "<set name='" . $ors['evt_computer'] . "' value='" . $ors['Count'] . "' />";
}
mysql_close($link); $strXML .= "</graph>";
//Create the chart
echo renderChart("Column3D.swf", "", $strXML, "ChartId", 650, 450, false, false);
Regards,
Sudipto Choudhury
FusionCharts Team
|
|
|
|