請問各位大大:為什麼查詢不到我要的資料
我做了二頁
1.php
<?php require_once('Connections/FADS_Database_Link.php'); ?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
$colname_Recordset1 = "1";
if (isset($_GET['keyword'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['keyword'] : addslashes($_GET['keyword']);
}
mysql_select_db($database_FADS_Database_Link, $FADS_Database_Link);
$query_Recordset1 = sprintf("SELECT * FROM fadata WHERE issue LIKE '%%%s%%'", $colname_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $FADS_Database_Link) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
$queryString_research = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_research") == false &&
stristr($param, "totalRows_research") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_research = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_research = sprintf("&totalRows_research=%d%s", $totalRows_research, $queryString_research);
?>
<!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" content="text/html; charset=utf-8">
<title</title>
</head>
<body>
<form name="form1" method="get" action="2.php">
<p>keywrod:
<input name="keyword" type="text" id="keyword">
<input type="submit" name="Submit" value="送出">
</p>
</form>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
------------------------------------------------------
2.php
<?php require_once('Connections/FADS_Database_Link.php'); ?>
<?php
mysql_select_db($database_FADS_Database_Link, $FADS_Database_Link);
$query_Recordset1 = "SELECT * FROM fadata";
$Recordset1 = mysql_query($query_Recordset1, $FADS_Database_Link) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!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" content="text/html; charset=utf-8">
<title>無標題文件</title>
</head>
<body>
<table width="801" border="1">
<tr>
<td width="92" height="25">aid</td>
<td width="693">issue</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_Recordset1['aid']; ?></td>
<td><?php echo $row_Recordset1['issue']; ?></td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
<p><a href="1.php">上一頁</a></p>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
請教各位大大