Additional information
That's what I suspected. I'm including the code from coherence_scale_data1.php in the text of this message, and the data table (la_scores.php) as an upload.
<?php require_once('../../Connections/Assessment.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
?>
<?php
mysql_select_db($database_Assessment, $Assessment);
$query_WADWCla_scores = "SELECT lasname_1a AS XLABEL, coherence_framing AS YVALUE FROM la_scores ORDER BY lasname_1a ASC";
$WADWCla_scores = mysql_query($query_WADWCla_scores, $Assessment) or die(mysql_error());
$row_WADWCla_scores = mysql_fetch_assoc($WADWCla_scores);
$totalRows_WADWCla_scores = mysql_num_rows($WADWCla_scores);
?>
<?php echo "<" . "?xml version=\"1.0\" encoding=\"utf-8\" ?".">"; ?><!DOCTYPE wa_dwc SYSTEM "wa_dwc.dtd">
<wa_dwc name="DTS" version="1.0">
<color_wheel name="SLATE">
<color>#173232</color>
<color>#7171</color>
<color>#70c7b1</color>
<color>#9696</color>
<color>#faeedb</color>
<color>#e0aa81</color>
</color_wheel>
<title style=" font-size:14px; color:#303431; text-align:center;">FRAMING</title>
<background color="#F4F6F2" align="left" valign="top"/>
<innerbg startcolor="#dcebe2" endcolor="#7cbaaa" direction="90"/>
<yaxis color="#568176" gridcolor="#6da496">
<labels size="11" fontcolor="#3b6e72" linecolor="#6da496">
</labels>
<legend size="12" color="#173232">Framing</legend>
</yaxis>
<xaxis color="#568176" gridcolor="#6da496" offset="true">
<legend size="12" color="#2d2b2e">Phase%20score</legend>
<labels size="11" fontcolor="#3b6e72" orientation="2" linecolor="#6da496">
</labels>
</xaxis>
<data>
<dataset style="{font-size:9px;color:#767a7f;}" size="9" width="2" color="#173232" label="Scores" dotsize="5" opacity="80" abstraction="4" outline="#568176" linecolor="#568176" type="bar" subtype="fade">
<?php do { ?><point >
<label><?php echo($row_WADWCla_scores['XLABEL']); ?></label>
<value><?php echo($row_WADWCla_scores['YVALUE']); ?></value>
</point><?php } while ($row_WADWCla_scores = mysql_fetch_assoc($WADWCla_scores)); ?>
</dataset>
</data>
</wa_dwc>
<?php
mysql_free_result($WADWCla_scores);
?>