03.<head>
04.<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
05.<title>Untitled Document</title>
06.</head>
07.
08.<body>
09.
10.
11.<p>
12. <?
13.$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
14.$objDB = mysql_select_db("mydatabase");
15.$strSQL = "SELECT * FROM shortcode order by ShortcodeName DESC ";
16.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
17.?>
18.</p>
19.<table width="932" border="2">
20. <p> </p>
21.
22.<tr div align="left" bordercolor="#FF0033" bgcolor="#FFCCFF"><font size="4" color="#0000FF">Date Time:<?
23.echo date("Y-m-d h:i:s");
24.?></font></tr>
25.
26.
27. <tr> <B>
28. <th width="100" bgcolor="#FFFFFF" bordercolor="#006666"><font size="4"color="#0000FF"><div align="center">Shortcode_id</div></font></th>
29. <th width="100" bgcolor="#FFFFFF" bordercolor="#006666"><font size="4"color="#0000FF"> <div align="center">Company_name</div></font></th>
30. <th width="100" bgcolor="#FFFFFF" bordercolor="#006666"><font size="4"color="#0000FF"> <div align="center">Effect-time</div></font></th>
31. <th width="100" bgcolor="#FFFFFF" bordercolor="#006666"><font size="4"color="#0000FF"> <div align="center">Expire-time</div></font></th>
32. <th width="100" bgcolor="#FFFFFF" bordercolor="#006666"><font size="4"color="#0000FF"> <div align="center">tel</div></font></th>
33. <th width="100" bgcolor="#FFFFFF" bordercolor="#006666"><font size="4"color="#0000FF"> <div align="center">Delete</div></font></th>
34. <th width="100" bgcolor="#FFFFFF" bordercolor="#006666"><font size="4"color="#0000FF"> <div align="center">Edit</div></font></th>
35. </B></tr>
36. <?
37.while($objResult = mysql_fetch_array($objQuery))
38.{
39.?>
40.<tr>
41.<td><div align="center"><?=$objResult["ShortcodeName"];?></div></td>
42.<td><div align="center"><?=$objResult["Company"];?></div></td>
43.<td><div align="center"><?=$objResult["Effect_time"];?></div></td>
44.<td><div align="center"><?=$objResult["Expire_time"];?></div></td>
45.<td align="center"><?=$objResult["Tel"];?></td>
46.
47.<td align="center"><a href="JavaScript:if(confirm('Confirm Delete?')==true){window.location='phpMySQLDeleteRecord.php?ShortID=<?=$objResult["ShortcodeName"];?>';}">Delete</a></td>
48.<td align="center" ><a href="phpMySQLEditRecordForm.php?ShortID=<?=$objResult["ShortcodeName"];?>">Edit</a></td>
49.
50.
51.</tr>
52.<?
53.}
54.?>
55.</table>
56. <?
57.mysql_close($objConnect);
58.?>
59.
60.
61.</body>
62.</html>
ไม่นึกว่าพี่วินจะมีแฟนคลับเป็นชาวต่างชาติด้วย ปลื้มแทนครับ 
