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("mydatabase");
09.$strSQL = "SELECT * FROM customer";
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">CustomerID </div></th>
15. <th width="98"> <div align="center">Name </div></th>
16. <th width="198"> <div align="center">Email </div></th>
17. <th width="97"> <div align="center">CountryCode </div></th>
18. <th width="59"> <div align="center">Budget </div></th>
19. <th width="71"> <div align="center">Used </div></th>
20. <th width="30"> <div align="center">Edit </div></th>
21. </tr>
22.<?
23.while($objResult = mysql_fetch_array($objQuery))
24.{
25.?>
26. <tr>
27. <td><div align="center"><?=$objResult["CustomerID"];?></div></td>
28. <td><?=$objResult["Name"];?></td>
29. <td><?=$objResult["Email"];?></td>
30. <td><div align="center"><?=$objResult["CountryCode"];?></div></td>
31. <td align="right"><?=$objResult["Budget"];?></td>
32. <td align="right"><?=$objResult["Used"];?></td>
33. <td align="center"><a href="phpMySQLEditRecordForm.php<span style="background-color:red;">?CusID</span>=<?=$objResult["CustomerID"];?>">Edit</a></td>
34. </tr>
35.<?
36.}
37.?>
38.</table>
39.<?
40.mysql_close($objConnect);
41.?>
42.</body>
43.</html>
