<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<form id="form1" name="form1" method="post" action="">
<p align="center">日期/时间：
<input name="Stime" type="text" id="Stime" value="2009-09-04 %" />
电话号码：
<input name="Phone" type="text" id="Phone" value="12345678" />
<input type="submit" name="Submit" value="提交" />
</p>
</form>
<?
//数据库信息
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "123456";
$mysql_database = "abcdefg";
//连接数据库
$conn=mysql_connect( $mysql_server_name, $mysql_username, $mysql_password );
//数据库编码类型
mysql_query("set names utf8");
//Mysql语句
$sql = sprintf("SELECT * FROM `varlog` WHERE `call_date` LIKE '%s' AND `phone_number` LIKE '%s' LIMIT 0 , 30 ",$_POST['Stime'],$_POST['Phone']);
//选取数据库，执行Mysql语句
$result=mysql_db_query( $mysql_database, $sql,$conn );
//mysql_fetch_array输出一个阵列
$row=mysql_fetch_array($result);
//print_r ($row);
//echo "\n";
?>
<table border="1" align="center">
<tr>
<td><div align="center">Uid</div></td>
<td><div align="center">List_id</div></td>
<td><div align="center">campaign_id</div></td>
<td><div align="center">call_date</div></td>
<td><div align="center">length_in_sec</div></td>
<td><div align="center">status</div></td>
<td><div align="center">phone_code</div></td>
<td><div align="center">phone_number</div></td>
<td><div align="center">user</div></td>
<td><div align="center">comments</div></td>
<td><div align="center">processed</div></td>
<td><div align="center">user_group</div></td>
</tr>
<?
while($row=mysql_fetch_array($result))
{
// print_r($row);
?>
<tr>
<td> <div align="center"><? echo $row["uniqueid"]; ?></div></td>
<td><div align="center"><? echo $row["list_id"]; ?></div></td>
<td><div align="center"><? echo $row["campaign_id"]; ?></div></td>
<td><div align="center"><? echo $row["call_date"]; ?></div></td>
<td><div align="center"><? echo $row["length_in_sec"]; ?></div></td>
<td><div align="center"><? echo $row["status"]; ?></div></td>
<td><div align="center"><? echo $row["phone_code"]; ?></div></td>
<td><div align="center"><? echo $row["phone_number"]; ?></div></td>
<td><div align="center"><? echo $row["user"]; ?></div></td>
<td><div align="center"><? echo $row["comments"]; ?></div></td>
<td><div align="center"><? echo $row["processed"]; ?></div></td>
<td><div align="center"><? echo $row["user_group"]; ?></div></td>
</tr>
<?
}
?>
</table>
<?
//显示之后释放结果
mysql_free_result($result);
?>
这个为什么在表单都输入％ 号就可以显示出一片记录，可是如果我想准确的查询一个就不会显示一个记录，
while($row=mysql_fetch_array($result))
{
print_r($row);
这里不管是查％还是准确的查询一个记录 Print_r（$row);都会印出阵列，删除
while($row=mysql_fetch_array($result))
{
｝
可以准备的查询一个记录，这是为什么，我的代码有错吗？
