AjnabiZ
Members-
Content count
4 -
Joined
-
Last visited
About AjnabiZ
-
Rank
Forum Newbie
-
[MySQL Chart] Values being shown multiple times
AjnabiZ replied to AjnabiZ's topic in FusionCharts and PHP
Thanks a lot I will check it out to see it it works. -
[MySQL Chart] Values being shown multiple times
AjnabiZ replied to AjnabiZ's topic in FusionCharts and PHP
Hello Can anyone tell me what settings to make when there are 1000+ customers and I need to show their totals. The graphs will get jumbled with so many names. Is there a way to show , let say, 10 customers , then click next to see the Next 10 and so on. -
[MySQL Chart] Values being shown multiple times
AjnabiZ replied to AjnabiZ's topic in FusionCharts and PHP
Hello Thanks alot for a quick reply as well as the fix. I added the distinct user_id and name to the sql statement and it worked fine :Wow: -
Hello I am trying to implement fusioncharts evaluation version with my shopping cart. Here is the problem : I have attached a screenshot as well. I have trying to show "Total Sales by Customer". I do get the total amount correctly, but it is being displayed multiple times. Here is the PHP Code im using : <?php //Connect to the DB $link = connectToDB(); //$strXML will be used to store the entire XML document generated //Generate the chart element $strXML = ""; //Fetch all factory records $strQuery = "select * from va_orders"; $result = mysql_query($strQuery) or die(mysql_error()); //Iterate through each factory if ($result) { while($ors = mysql_fetch_array($result)) { //Now create a second query to get details for this factory $strQuery = "select sum(order_total) as OrderTotal from va_orders where user_id=" . $ors['user_id']; $result2 = mysql_query($strQuery) or die(mysql_error()); $ors2 = mysql_fetch_array($result2); //Generate $strXML .= ""; //free the resultset mysql_free_result($result2); } } mysql_close($link); //Finally, close element $strXML .= ""; //Create the chart - Pie 3D Chart with data from $strXML echo renderChart("../FusionCharts/Column3D.swf", "", $strXML, "FactorySum", 600, 300, false, false); ?>