code ผมผิดตรงไหนครับ ทำยังไงก้อไม่เปลี่ยนข้อมูลอ่ะครับผม
<?php
include "chksession.php";
?>
<html>
<head>
<title>.:::: EDIT Client :::.</title>
</head>
<body bgcolor=#FFCC33>
<table border="1" cellpadding="5" cellspacing="2" align="center">
<tr align="center">
<td><b>ID</b></td><td><b>Code</b></td><td><b>Name</b></td><td><b>Ip</b></td>
</tr>
<?php
include( "connectmember.php" );
mysql_select_db( $dbname, $c )
or die ( "ไม่สามารถเลือกใช้งานฐานข้อมูล $dbname ได้" );
if ( isset( $client_id ) && isset( $client_code ) && isset( $client_name ) && isset( $client_ip ) )
{
$strSQL = "UPDATE aftnclient ";
$strSQL = $strSQL . "SET client_code='$client_code', client_name='$client_name', client_ip='$client_ip' ";
$strSQL = $strSQL . "WHERE client_id=$client_id";
$result = mysql_query( $strSQL, $c );
if ( ! $result )
die ( "ไม่สามารถปรับปรุงข้อมูลได้ : " . mysql_error() );
}
$strSQL = "SELECT * FROM aftnclient";
$result = mysql_query( $strSQL, $c );
$Total = mysql_num_rows( $result );
while ( $rs = mysql_fetch_array( $result ) )
{
echo "<tr>\n";
echo "\t<td>$rs[client_id]</td><td>$rs[client_code]</td><td>$rs[client_name]</td><td>$rs[client_ip]</td>\n";
echo "</tr>\n";
}
echo "</table>\n";
echo "<p>มีข้อมูลทั้งหมด <b>$Total</b> ระเบียน";
echo "
<form method=post action=\"$PHP_SELF\">
<table border=\"0\" cellpadding=\"3\" cellspacing=\"0\">
<tr>
<td align=\"right\">ID :</td>
<td>
<select name=\"client_id\">
";
$result = mysql_query( "SELECT * FROM aftnclient" );
while ( $rs = mysql_fetch_object( $result ) )
{
echo "\t\t\t<option value=\"$rs->client_id\">$rs->client_id\n";
}
echo "
</select>
</td>
</tr>
<tr>
<td align=\"right\">Code :</td>
<td><input type=\"text\" name=\"client_code\" size=\"20\"></td>
</tr>
<tr>
<td align=\"right\">Name :</td>
<td><input type=\"text\" name=\"client_name\" size=\"20\"></td>
</tr>
<tr>
<td align=\"right\">Ip :</td>
<td><input type=\"text\" name=\"client_ip\" size=\"20\"></td>
</tr>
<tr>
<td colspan=\"2\" align=\"right\"><input type=\"submit\" value=\"เปลี่ยนแปลงข้อมูล\"></td>
</tr>
</table>
</form>
";
mysql_close( $c );
?>
<center>
[<a href="show_client2.php"> <b>กลับหน้าเดิม</b></a> ]
</center>
</body>
</html>
