01.<html>
02.<head>
03.<title>ThaiCreate.Com PHP & MySQL Tutorial</title>
04.</head>
05.<body>
06.<?
07.$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
08.$objDB = mysql_select_db("member");
09.$strSQL = "SELECT * FROM member";
10.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
11.?>
12.<table width="600" border="1">
13. <tr>
14. <th width="91"> <div align="center">รายชื่อ</div></th>
15. <th width="98"> <div align="center">เวลา</div></th>
16. </tr>
17.<?
18.while($objResult = mysql_fetch_array($objQuery))
19.{
20.?>
21. <tr>
22. <td align="right"><?=$objResult["fullname"];?></td>
23. <td align="right"><?=$objResult["idin"];?></td>
24. <td align="right"><?=$objResult["date"];?></td>
25. </tr>
26.<?
27.}
28.?>
29.</table>
30.<?
31.mysql_close($objConnect);
32.?>
33.</body>
34.</html>
