require "../teacher/settings.php";
$course_ID=$_GET['ID'];
$link=mysql_connect($DB_server,$DB_name,$DB_passwd);
$db=mysql_select_db($DB_name,$link);
$cmd="SELECT name,teacher_ID FROM course where ID=$course_ID";
$resource=mysql_query($cmd,$link);
$data=mysql_fetch_row($resource);
$teacher_ID=$data[1];
?>
電子系-學生問題討論區列表
|
|
|
|
|
|
|
echo $data[0];?>討論區 |
|
發表新問題或主題
已發表的討論問題或主題 |
老師回覆 |
其他回覆 |
$cmd="select ID,title,teacher_rsp from discussion where (course_ID=$course_ID AND response_ID=0) order by datetime desc" ;
$resource=mysql_query($cmd,$link);
while($data=mysql_fetch_assoc($resource)){
?>
echo $data['title'];?> |
if($data['teacher_rsp']) echo"已回覆"; else echo"未回覆";?>
|
$cmd="select ID from discussion where response_ID=".$data['ID']." AND is_teacher=0 order by datetime desc ";
$resource2=mysql_query($cmd,$link);
$cnt=mysql_num_rows($resource2);
?>
echo $cnt;?> |
}?>
返回上層列表 |
|
|
|
mysql_free_result($resource);
mysql_free_result($resource2);
mysql_close($link);
?>