$q = "SELECT testvalue,alertlevel,recordx FROM fnrecord WHERE testid=\"" . ss($_REQUEST['testid']) . "\" ";
$q .= "AND recordx>=" . ss($startx) . " AND recordx<=" . ss($finishx) . " ORDER BY recordx ASC";
//$q.="LIMIT 0,100";
$r = $NATS->DB->Query($q);
$lastx = 0;
$lasty = 0;
$startval = 0;
$finishval = 0;
while ($row = mysqli_fetch_array($r)) {
$x = posx($row['recordx']);
//$y=posy($row['testvalue']);
$val = $row['testvalue'];
if ($val < 0) {
$y = posy(0);
} else {
$y = posy($val);
}
if ($row['alertlevel'] == -1) {
$c = $col['grey'];
} else {
if ($row['alertlevel'] == 0) {
$c = $col['lightgreen'];
} else {
if ($row['alertlevel'] == 1) {
$c = $col['orange'];
} else {
if ($row['alertlevel'] == 2) {
$c = $col['red'];
} else {
$c = $col['black'];
}
$q.="AND recordx>=".ss($startx)." AND recordx<=".ss($finishx)." ORDER BY recordx ASC";
//$q.="LIMIT 0,100";
$r=$NATS->DB->Query($q);
$lastx=0;
$lasty=0;
$startval=0;
$finishval=0;
while ($row=mysql_fetch_array($r))
{
$x=posx($row['recordx']);
//$y=posy($row['testvalue']);
$val=$row['testvalue'];
if ($val<0) $y=posy(0);
else $y=posy($val);
if ($row['alertlevel']==-1) $c=$col['grey'];
else if ($row['alertlevel']==0) $c=$col['lightgreen'];
else if ($row['alertlevel']==1) $c=$col['orange'];
else if ($row['alertlevel']==2) $c=$col['red'];
else $c=$col['black'];
// up lines
if ($draw_spike==1) imageline($im,$x,ty(0),$x,ty($y),$c);
if ($lastx!=0)
{
