$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) {