01.<form name="form" id="form">
02. ประเภทคดี
03. <label>
04. <select name="jumpMenu" id="jumpMenu" onchange="MM_jumpMenu('parent',this,0)">
05. <?
06. include ("connectDB.php");
07. mysql_query ("SET NAMES utf8") or die (mysql_errno());
08. $result = mysql_query("SELECT * FROM casestype");
09. while($row = mysql_fetch_array($result)){
10. ?>
11. <option value="?type=<? echo $row['CasesID'] ?>"><? echo $row['Type'] ?></option>
12. <? } ?>
13. </select>
14. </label>
15. </form>
16. <p></p>
17. <?
18. include ("datethai.php");
19. include ("connectDB.php");
20. $type = $_REQUEST["Type"];
21. $sql = "SELECT * FROM `cases` Where Type = '".$_GET["type"]."'";
22. $result = mysql_query($sql);
23. echo"<table width='90%' border='1' style='border-collapse: collapse' bordercolor='#A59A1B' bgcolor='#D3BC38' ><tr align='center'>
24. <td><b>เลขที่คดี</b></td>
25. <td><b>วันที่</b></td>
26. <td><b>ประเภทคดี</b></td>
27. <td><b>รายละเอียด</b></td>
28. <td><b>ผู้ต้องหา</b></td>
29. <td><b>เจ้าหน้าที่ผู้รับผิดชอบ</b></td>
30. </tr>";
31. while($row=mysql_fetch_array($result)){
32. $caseid = $row["CaseID"];
33. $casedate = DateThai($row["CaseDate"]);
34. $type = $row["Type"];
35. $description = $row["Description"];
36. $captive = $row["Captive"];
37. $casepolice = $row["CasePolice"];
38. echo "<tr bgcolor='#D3BC38' align='center'>";
39. echo "<td>$caseid</td>";
40. echo "<td>$casedate</td>";
41. echo "<td>$type</td>";
42. echo "<td><a href=\"ShowCase1.php?CaseID=$caseid\" target=\"$caseid\">คลิก</td>";
43. echo "<td>$captive</td>";
44. echo "<td>$casepolice</td>";
45. echo "</td></form></tr>";
46. }
47. echo "</table>";
48.?>
