01.<html>
02.<head>
03.
04.</head>
05.<body>
06.<form action="updatesave2.php?CusID=<?php echo $_GET["CusID"];?>" name="frmEdit" method="post">
07.<?php
08.include("bar.php");
09.include("config.php");
10.$strSQL = "SELECT * FROM v_studentmail WHERE CitizenID = '".$_GET["CusID"]."' ";
11.
12.$objQuery = mssql_query($strSQL);
13.$objResult = mssql_fetch_array($objQuery);
14.if(!$objResult)
15.{
16. echo "Not found CitizenID=".$_GET["CusID"];
17.}
18.else
19.{
20.?>
21.<table width="600" border="1">
22. <tr>
23. <th width=""> <div align="center">CitizenID </div></th>
24. <th width=""> <div align="center">Prefix </div></th>
25. <th width="25"> <div align="center">FirstName </div></th>
26. <th width="25"> <div align="center">LastName </div></th>
27. <th width="25"> <div align="center">Tel-mobil1 </div></th>
28.
29. <th width="25"> <div align="center">Mail1 </div></th>
30. <th width="25"> <div align="center">WebMail1 </div></th>
31. <th width=""> <div align="center">CurLevel </div></th>
32. <th width=""> <div align="center">student_code_status </div></th>
33. <th width="71"> <div align="center">std_status </div></th>
34. <th width="71"> <div align="center">province </div></th>
35. </tr>
36. <tr>
37. <td><div align="center"><input type="text" name="txtCitizenID" size="10" value="<?php echo $objResult["CitizenID"];?>"></div></td>
38. <td><input type="text" name="txtPrefix" size="20" value="<?php echo $objResult["Prefix"];?>"></td>
39. <td><input type="text" name="txtFirstName" size="20" value="<?php echo $objResult["FirstName"];?>"></td>
40. <td><div align="center"><input type="text" name="txtLastName" size="20" value="<?php echo $objResult["LastName"];?>"></div></td>
41. <td align="right"><input type="text" name="txtTel-mobil1" size="20" value="<?php echo $objResult["Tel-mobil1"];?>"></td>
42. <td align="right"><input type="text" name="txtMail1" size="20" value="<?php echo $objResult["Mail1"];?>"></td>
43. <td align="right"><input type="text" name="txtWebMail1" size="20" value="<?php echo $objResult["WebMail1"];?>"></td>
44. <td align="right"><input type="text" name="txtCurLevel" size="20" value="<?php echo $objResult["CurLevel"];?>"></td>
45. <td align="right"><input type="text" name="txtstudent_code_status" size="20" value="<?php echo $objResult["student_code_status"];?>"></td>
46. <td align="right"><input type="text" name="txtstd_status" size="20" value="<?php echo $objResult["std_status"];?>"></td>
47. <td align="right"><input type="text" name="txtprovince" size="20" value="<?php echo $objResult["province"];?>"></td>
48.
49. </tr>
50. </table>
51. <input type="submit" name="submit" value="submit">
52. <?php
53. }
54. mssql_close($objConnect);
55. ?>
56. </form>
57.</body>
58.</html>
