hewei19810821
新手上路
UID 72285
精华
0
积分 36
帖子 23
金钱 36 喜悦币
威望 0
人脉 0
阅读权限 10
注册 2006-4-24
状态 离线
|
问个大家一直困扰到我的问题
<?
include("sbconfig.php");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>设备维护表</title>
</head>
<body>
<form action="file:///D|/usr/www/html/sbgl/whbadd.php" method="post">
<table width="78%" border="1" align="center">
<tr>
<td colspan="4"> 组 合 查 询 </td>
</tr>
<tr>
<td width="17%" align="center">月份
<select name="yue" >
<option value="1m" selected>1月</option>
<option value="2m">2月</option>
<option value="3m">3月</option>
<option value="4m">4月</option>
<option value="5m">5月 </option>
<option value="6m">6月</option>
<option value="7m">7月</option>
<option value="8m">8月</option>
<option value="9m">9月</option>
<option value="10m">10月</option>
<option value="11m">11月</option>
<option value="12m">12月</option>
</select >
</td>
<td width="23%" align="center">单位 <select name="danwei">
<option value="quan" selected >全部</option>
<option value="一铸" >一铸</option>
<option value="二铸">二铸</option>
<option value="三铸">三铸</option>
</select></td>
<td width="20%" align="center">维护类型 <select name="leixing">
<option value="全部" selected >全部</option>
<option value="a" >A类 </option>
<option value="b">B 类</option>
</select> </td>
<td align="center"><input type="submit" name="Submit" value="确定"> </td>
</tr>
</table>
</form>
<?
if(empty($_POST["yue"]))
{
exit;
}
?>
<table width="78%" border="1" align="center">
<tr>
<td width="27%" align="center">设备名称</td>
<td width="19%">所属单位</td>
<td width="23%">类型</td>
<td width="15%">检查</td>
<td width="16%">进入</td>
</tr>
<?
$yue=$_POST["yue"];
$danw=$_POST["danwei"];
$lx=$_POST["leixing"];
$i=0;
$db=mysql_connect($servername,$sqlservername,$sqlserverpws) or die("数据库连接失败，请检查！");
mysql_select_db($sqlname,$db);
$sql="select * from $sqltable1 where $yue='wh' and danwei='$danw' and leixing='$lx'" ;
$conn=mysql_query($sql) or die(mysql_error());
while($rs=mysql_fetch_array($conn)){
$nm = $rs["name"];
$danwe = $rs["danwei"];
$sql2="select * from $sqltable2 where name='$nm' and danwei ='$danwe'and month = '$yue' ";
$conn2=mysql_query($sql2) or die(mysql_error());
while($rs2=mysql_fetch_array($conn2)){
echo($rs2["name"]);
}
}
?>
</table>
</body>
</html>
为什么在$sqltable2 表中的数据出不来哪?
难道是WHILE的双重循环有问题吗?
谢谢大家看看
|
|
