01.<?
02.print"<table width=532 border=1 align=center cellpadding=1 cellspacing=1 bordercolor=0000FF>";
03.print"<tr>";
04.print"<td width=703>";
05.print"<table width=532 align=center>";
06.print"<tr bgcolor=003399>";
07.print"<td align = center><font color=FF6600><b>รหัสกระทู้</b></font></td>";
08.print"<td align=center><font color=FF6600><b>หัวข้อกระทู้</b></font></td>";
09.print"<td align=center><font color=FF6600><b>ผู้ตั้งคำถาม</b></font></td>";
10.print"<td align=center><font color=FF6600><b>วันที่ตั้งคำถาม</b></font></td>";
11.print"<td align=center><font color=FF6600><b>จำนวนผู้ตอบ</b></font></td>";
12.if(!empty($admin))
13.{print"<td align=center><font color=FF6600><b>delete</b></font></td>";}
14.print"</tr>";
15.
16.include('config.inc.php');
17.$sql="Select * From quiz Order By id_question DESC";
18. $result=mssql_query($sql);
19. while($row=mssql_fetch_array($result))
20. {
21. $id_question=$row['id_question'];
22. $sql_a="Select * From ans Where id_question='$id_question' ";
23. $result_a=mssql_query($sql_a);
24.
25. $sum=mssql_num_rows($result_a);}
26.
27.
28.$sql="select*from quiz order by id_question desc";
29.$dbquery= mssql_query($sql);
30.$num_rows=mssql_num_rows($dbquery);
31.$i=0;
32.while($i<$num_rows)
33. {
34. $rs=mssql_fetch_array($dbquery);
35. $id_question=$rs[id_question];
36. $title=$rs[title];
37. $name=$rs[name];
38. $message=$$rs[message];
39. $email=$rs[email];
40. $date_q=$rs[date_q];
41. $count_q=$rs[count_q];
42.
43.
44. print"<tr bgcolor=CCCCCC>";
45. print"<td>".$id_question."</td>";
46. print"<td><A HREF=\"ans.php?id_question=$id_question\"target=\"$id_question\">$title</A></td>";
47. print"<td>".$name."</td>";
48. print"<td>".$date_q."</td>";
49.
50. print"<td>".$sum."</td>";
51. if(!empty($admin))
52. {print"<td><A HREF=\"del_webboard_admin.php?id_question=$id_question\">delete</a></td>";}
53. print"</tr>";
54. $i++;
55. }
56.print"</table>";
57.mssql_close();
58.print"</td>";
59.print"</tr>";
60.print"</table>";
61.
62.?>
