01.<form action="EditSave.php?PES_ID=<?=$_GET["PES_ID"];?>" name="frmEdit" method="post">
02.<?
03.$objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
04.$objDB = mysql_select_db("Projectfinal");
05.$strSQL = "SELECT * FROM PES WHERE PES_ID = '".$_GET["PES_ID"]."' ";
06.$objQuery = mysql_query($strSQL);
07.$objResult = mysql_fetch_array($objQuery);
08.if(!$objResult)
09.{
10.echo "Not found PES_ID=".$_GET["PES_ID"];
11.}
12.else
13.{
14.?>
15. <table width="764" border="1">
16. <tr>
17. <th width="78"> <div align="center">Name </div></th>
18. <th width="140"> <div align="center">Lastname </div></th>
19. <th width="95">ValueMarket</th>
20. <th width="95">Contract</th>
21. <th width="95">Match</th>
22. <th width="95"> <div align="center">Goal </div></th>
23. <th width="56"> <div align="center">Assist </div></th>
24. <th width="58"> <div align="center">Salary </div></th>
25. </tr>
26.<tr>
27. <td><div align="center"><input name="PES_Name" type="text" id="PES_Name" value="<?=$objResult["PES_Name"];?>" size="5"></div></td>
28.<td><input name="PES_Lastname" type="text" id="PES_Lastname" value="<?=$objResult["PES_Lastname"];?>" size="5"></td>
29.<td><input name="ValueMarket" type="text" id="PES_Contract" value="<?=$objResult["ValueMarket"];?>" size="5"></td>
30.<td><div align="center"><input name="PES_Contract" type="text" id="PES_Contract" value="<?=$objResult["PES_Contract"];?>" size="5"></div></td>
31.<td align="right"><input name="Match" type="text" id="Match" value="<?=$objResult["Macth"];?>" size="5"></td>
32.<td align="right"><input name="Goal" type="text" id="Goal" value="<?=$objResult["Goal"];?>" size="5"></td>
33.<td align="right"><input name="Assist" type="text" id="Assist" value="<?=$objResult["Assist"];?>" size="5"></td>
34.<td align="right"><input name="PES_Salary" type="text" id="PES_Salary" value="<?=$objResult["PES_Salary"];?>" size="5"></td>
35.</tr>
36.</table>
37.<input type="submit" name="submit" value="submit">
38.<?
39.}
40.mysql_close($objConnect);
41.?>
42.</form>
Quote:
