01.<?
02.$objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
03.$objDB = mysql_select_db("projectfinal");
04.$strSQL = "SELECT * FROM PES";
05.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
06.?>
07.<table width="679" border="1">
08.<tr>
09.<th width="84"> <div align="center">Player_ID </div></th>
10.<th width="78"> <div align="center">Name </div></th>
11.<th width="140"> <div align="center">Lastname </div></th>
12.<th width="95"> <div align="center">Goal </div></th>
13.<th width="56"> <div align="center">Assist </div></th>
14.<th width="58"> <div align="center">Salary </div></th>
15.<th width="122"> <div align="center">แก้ไข</div></th>
16.</tr>
17.<?
18.while($objResult = mysql_fetch_array($objQuery))
19.{
20.?>
21.<tr>
22.<td><div align="center"><?=$objResult["PES_ID"];?></div></td>
23.<td><?=$objResult["PES_Name"];?></td>
24.<td><?=$objResult["PES_Lastname"];?></td>
25.<td><div align="center"><?=$objResult["Goal"];?></div></td>
26.<td align="right"><?=$objResult["Assist"];?></td>
27.<td align="right"><?=$objResult["PES_Salary"];?></td>
28.<td align="center"><a href="Editlistplayer.php?PES_ID=<?=$objResult["PES_ID"];?>">Edit</a></td>
29.</tr>
30.<?
31.}
32.?>
33.</table>
34.<?
35.mysql_close($objConnect);
36.?>
