我的机器环境：IIS6.0+Mysql+PHP
建立数据库：ykq
建立表：chykq，5列：ID 、dsjxh、ykqxinghao、CPUxinghao、ykqxingpian。
已经输入大量数据。下面是我的资料输入页面，我自己制作的：http://www.shanlei.sd.cn/ykq/ch-ykqluru.php
用英文版本的PHPRun制作了一个数据库资料查询修改页面：点击查看
用户名：
www.wxzzj.com 密码：shanlei
因为查询页面是英文的，非常不方便。所以我想自己写一个数据库查询修改页面，历时10多天没有成功，大家帮我看一下，是哪儿出错误了！
搜索页代码：
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" c>
<title>无标题文档</title>
</head>
<body>
<form action="2.php" method="get" name="dsj" id="dsj">
电视机型号：
<input type="text" name="textfield">
<input type="submit" name="Submit" value="提交">
</form>
</body>
</html>
结果页代码：
<?php require_once('Connections/shan.php'); ?>
<?php
$maxRows_Recordset112 = 10;
$pageNum_Recordset112 = 0;
if (isset($_GET['pageNum_Recordset112'])) {
$pageNum_Recordset112 = $_GET['pageNum_Recordset112'];
}
$startRow_Recordset112 = $pageNum_Recordset112 * $maxRows_Recordset112;
$colname_Recordset112 = "1";
if (isset($_GET['textfield'])) {
$colname_Recordset112 = (get_magic_quotes_gpc()) ? $_GET['textfield'] : addslashes($_GET['textfield']);
}
mysql_select_db($database_shan, $shan);
$query_Recordset112 = sprintf("SELECT * FROM chykq WHERE dsjxh = '%s'", $colname_Recordset112);
$query_limit_Recordset112 = sprintf("%s LIMIT %d, %d", $query_Recordset112, $startRow_Recordset112, $maxRows_Recordset112);
$Recordset112 = mysql_query($query_limit_Recordset112, $shan) or die(mysql_error());
$row_Recordset112 = mysql_fetch_assoc($Recordset112);
if (isset($_GET['totalRows_Recordset112'])) {
$totalRows_Recordset112 = $_GET['totalRows_Recordset112'];
} else {
$all_Recordset112 = mysql_query($query_Recordset112);
$totalRows_Recordset112 = mysql_num_rows($all_Recordset112);
}
$totalPages_Recordset112 = ceil($totalRows_Recordset112/$maxRows_Recordset112)-1;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" c>
<title>无标题文档</title>
</head>
<body>
<form name="form1" method="post" action="">
<table border="1" cellpadding="1" cellspacing="1">
<tr>
<td>ID</td>
<td>dsjxh</td>
<td>ykqxinghao</td>
<td>CPUxinghao</td>
<td>ykqxinpian</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_Recordset112['ID']; ?></td>
<td><?php echo $row_Recordset112['dsjxh']; ?></td>
<td><?php echo $row_Recordset112['ykqxinghao']; ?></td>
<td><?php echo $row_Recordset112['CPUxinghao']; ?></td>
<td><?php echo $row_Recordset112['ykqxinpian']; ?></td>
</tr>
<?php } while ($row_Recordset112 = mysql_fetch_assoc($Recordset112)); ?>
</table>
</form>
</body>
</html>
<?php
mysql_free_result($Recordset112);
?>
用get和POST的方式都试过，结果页显示的是数据库相应表格的全部数据，不知道该如何修改，请高手指点。
