In Firefox 2.0.2 all charts display fine. In Firefox 3.0.5 it only shows the first chart.
===================
$q = "SELECT dayofweek(eventdate) as dow, date_format(eventdate,'%W') as dayname from $db1.event_detail WHERE locid = $locid AND eventtype IN(1,2) group by dayofweek(eventdate)";
$resultx = mysql_query($q) or die(mysql_error());
while($ors1 = mysql_fetch_array($resultx)) {
$dow = $ors1['dow'];
$dayname = $ors1['dayname'];
$strXML = "<chart showYAxisValues='1' yAxisMaxValue='125' yAxisMinValue='5' lineColor='863218' lineThickness='5' showZeroPlane='0' showLegend='0' anchorBorderColor='000000' anchorRadius='5' anchorBgColor='EDDFAF' bgColor='5E2312' bgAlpha='100' baseFontColor='000000' outCnvBaseFontColor='EDDFAF' baseFontSize='10' canvasBorderColor='000000' canvasBorderThickness='1' caption='Players Per Tournament'>";
$strXML .= "<categories>";
$strQuery = "SELECT date_format(eventdate,'%m/%d/%y') as eventdate1 from $db1.event_detail WHERE dayofweek(eventdate) = $dow AND event_detail.locid = $locid AND eventtype IN(1,2) order by eventdate desc";
$result = mysql_query($strQuery) or die(mysql_error());
if ($result) {
while($ors = mysql_fetch_array($result)) {
$strXML .= "<category label='" . $ors['eventdate1'] . "' /><vLine color='000000' thickness='1' />";
}
}
$strXML .="</categories>";
$strXML .="<dataset>";
$strQuery2 = "select eventdate,eventid,players,signups from $db1.event_detail where dayofweek(eventdate) = $dow AND locid=$locid and eventtype IN(1,2) order by eventdate desc";
$result3 = mysql_query($strQuery2) or die(mysql_error());
if ($result3) {
while($ors3 = mysql_fetch_array($result3)) {
$eventdate = $ors3['eventdate'];
$strXML .= "<set value='" . $ors3['players'] . "' link='P-detailsWin,width=500,height=500,toolbar=no,scrollbars=no, resizable=no-faq.php?locid=$locid%26amp;date=$eventdate' />";
}
}
$strXML .="</dataset>";
$strXML .="<dataset>";
$strQuery2 = "select signups from $db1.event_detail where dayofweek(eventdate) = $dow AND locid=$locid and eventtype IN(1,2) order by eventdate desc";
$result3 = mysql_query($strQuery2) or die(mysql_error());
if ($result3) {
while($ors3 = mysql_fetch_array($result3)) {
$eventdate = $ors3['eventdate'];
$strXML .= "<set value='" . $ors3['signups'] . "' link='P-detailsWin,width=500,height=500,toolbar=no,scrollbars=no, resizable=no-faq.php?locid=$locid%26amp;date=$eventdate' />";
}
}
$strXML .="</dataset>";
$strXML .="<trendLines>";
$strXML .= "<line startValue='60' color='009933' showOnTop='0' thickness='2' isTrendZone='0' displayvalue='Target' />";
$strXML .="</trendLines>";
$strXML .= "</chart>";
echo renderChart("Charts/ScrollLine2D.swf", "", $strXML, "", "725", 200, 0, false);
}
?>
