Above bar chart does not display data according to query result. According to your suggestion I have checked  xml file, according to that xml file it shows correct output.

But my problem is with the flag that I am using for setting the day label( means 9,11,12 in above example).Above bar chart should show day 4 before 9 & one bar of orange color on that day.But it shows that on  day '9'  instead of day '4'. This is happening because

of flag that I have used for setting day label( I am using the flag $catXMLDone that you have used in php & mysql free example multiseries example i.e. get sales by product bar chart). I am giving the following php  code. can you tell me the solution?

 $strXML = "<graph caption='Factory  Output ' subcaption='(In Units)' xAxisName='Date' formatNumberScale='0' decimalPrecision='0' palette='" . getPalette() . "' >";
 
   //To store categories - also flag to check whether category is already generated
  $catXMLDone = false;
 //Initialize XML elements
 $strCat = "<categories>";
 
 //First we need to get product type id from the database
  $strSQL = "SELECT DISTINCT(p.product_type_id) as ids FROM products as p WHERE p.product_type_id >='3' GROUP BY ids ";

 $result = mysql_query($strSQL) or die(mysql_error());
 
  //To store datasets and sets
    $strDataXML = "";
 
   if ($result)
   {
   
         while($orsCat = mysql_fetch_array($result))
      {
     
            //Add this category as dataset
            $strDataXML .= "<dataset seriesName='".$orsCat['ids']."' color='".getFCColor()."' >";

     $strSQL = "SELECT COUNT(oi.product_id) as Total,  Day(o.order_complete) as days,    p.product_type_id as typeid  FROM order_items as oi, orders as o,products as p WHERE p.product_type_id = '".$orsCat['ids']."' AND p.product_id = oi.product_id AND o.order_complete >= '2008-4-4 00:00:00' AND o.order_complete <= '2008-4-12 00:00:00' AND o.order_id = oi.order_id GROUP BY days";
     //Execute it
            $result2 = mysql_query($strSQL) or die(mysql_error());
            while($ors = mysql_fetch_array($result2))
             {
      
                     //Append <category label=''> if not already done
         
                    if (!$catXMLDone)
                    {
                   $strCat .= "<category name='" .$ors['days']. "' />";
       
                    }
                 //Append data
                   $strDataXML .= "<set value='" . $ors['Total'] . "'/>";
            }
            //Update flag that we've appended categories  
            $catXMLDone = true;
            //Clear up objects
            mysql_free_result($result2);
            //Close dataset element
            $strDataXML .= "</dataset>";
        }
    }

    //Close </categories>
 $strCat .= "</categories>";
 //Create full XML
 $strXML .= $strCat.$strDataXML;

    //Close <graph> element
    $strXML .= "</graph>";
 
    //Create the chart - Column 2D Chart with data from strXML
 echo renderChart("FusionCharts/FCF_MSColumn3D.swf", "", $strXML, "FactoryDetailed", 600, 300, false, false);