</TABLE>
<INPUT TYPE=SUBMIT VALUE="Spara förändringar">
<BR>
<TABLE WIDTH=60% BORDER=1 CELLPADDING=0 CELLSPACING=0>
<TR>
<TD COLSPAN=3><H2><? if($id){print "Ändra användare";}else{print "Skapa ny användare";}?></H2></TD>
<TR>
<TD>Grupp</TD><TD WIDTH=70%><INPUT TYPE=TEXT NAME="grupp" SIZE="48" VALUE="<?if($id){print $old_grupp;}else{print $grupp;} ?>"></TD>
<TD><INPUT TYPE=CHECKBOX NAME=Admin VALUE=1 <? if($old_admin==1){ print "CHECKED";} ?>>User Admin</TD>
</TR>
<TR>
<TD>Namn</TD><TD COLSPAN=2><INPUT TYPE=TEXT NAME="name" SIZE="48" VALUE="<? print $old_namn; ?>"></TD>
</TR>
<TR>
<TD>Username</TD><TD COLSPAN=2><INPUT TYPE=TEXT NAME="username" SIZE="48" VALUE="<? print $old_username; ?>"></TD>
</TR>
<TR>
<TD>Password</TD><TD COLSPAN=2><INPUT TYPE=TEXT NAME="password" SIZE="48"></TD>
</TR>
<TR>
<TD COLSPAN=3 align="right"><INPUT TYPE=SUBMIT NAME="Add" VALUE="<? if($id){print "Ändra";}else{print "Lägg till";} ?>"></TD>
</TR>
</TABLE>
</FORM>
<? meny(); ?>
</CENTER>
</BODY>
</HTML>
<? mysql_close($link); ?>
visaTabell($sql);
}
if ($vad == "subj") {
$sql = "select question_ID as fraga, rpad(question,50,'') as question, count(question_id) as antal, min(klar-start) as tidMin, max(klar-start) as tidMax, round(avg(klar-start),0) as tidMedel, min(Svar.points) as pntMin, max(Svar.points) as pntMax, round((avg(Svar.points)/max(Svar.points))*100,1) as ratt from Svar inner join Question on Svar.question_ID=Question.ID AND Question.subject_ID='" . $subj . "' GROUP BY question_ID";
visaTabell($sql);
}
if (isset($order)) {
$extra = "";
if ($prov != "") {
$extra = " AND Svar.prov_ID='" . $prov . "'";
}
if ($subj != "") {
$extra = " AND Question.subject_ID='" . $subj . "'";
}
$sql = "select question_ID as fraga, rpad(question,50,'') as question, count(question_id) as antal, min(klar-start) as tidMin, max(klar-start) as tidMax, round(avg(klar-start),0) as tidMedel, min(Svar.points) as pntMin, max(Svar.points) as pntMax, round((avg(Svar.points)/max(Svar.points))*100,1) as ratt from Svar inner join Question on Svar.question_ID=Question.ID" . $extra . " GROUP BY question_ID ORDER BY " . $order . " " . $otype;
visaTabell($sql);
}
?>
<?php
/* Skriva ut botten på sidan */
?>
<?php
meny();
?>
</form>
</body>
</html>
<?php
mysql_close($link);
