<?php  
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); 
header("Cache-Control: no-cache, must-revalidate"); 
header("Pragma: no-cache"); 
include("connect.php");
$query=mysql_query("select serial,name,master from item group by serial");
while($now1=mysql_fetch_array($query)){
$user= "<users>";  
$user.=" <serial>";    
$user.=$now1['serial'];
$user.= "</serial>";
$query1=mysql_query("select*from mask where item={$now1['serial']}");
 if ($query1) {while($now=mysql_fetch_array($query1)){
$user.=" <maskid>";    
$user.=$now['maskid'];
$user.= "</maskid>";
$user.=" <item>";    
$user.=$now['item'];
$user.= "</item>";$user.=" <maskname>";    
$user.=$now['maskname'];
$user.= "</maskname>";
$user.=" <date>";    
$user.=$now['date'];
$user.= "</date>";
$user.="<status>";    
$user.=$now['status'];
$user.= "</status>";
$user.="<completor>";    
$user.=$now['completor'];
$user.= "</completor>";
$user.="<percent>";    
$user.=$now['percent'];
$user.= "</percent>";
$user.="<comtime>";    
$user.=$now['comtime'];
$user.= "</comtime>";
$user.="<flag>";    
$user.=$now['flag'];
$user.= "</flag>";
$user.="<level>";    
$user.=$now['level'];
$user.= "</level>";
}
}
$user.=" <name>";    
$user.=$now1['name'];
$user.= "</name>";
$user.=" <master>";    
$user.=$now1['master'];
$user.= "</master>";
$user.= "</users>";   
echo $user;

解决方案 »

  1.   

    里面的查询
    query1=mysql_query("select*from mask where item={$now1['serial']}");
     if ($query1) {不能出来结果 为什么?谢谢了
      

  2.   

    $query1=mysql_query("select*from mask where item={$now1['serial']}") or die(mysql_error());
    看提示什么错误。
      

  3.   

    数据类型一样否?item字段类型是string的话:
    $query1=mysql_query("select * from mask where item='".$now1['serial']}."'")
    将$query1打出来,再将其帖到mysql中看看能否运行成功;
      

  4.   

    mysql_query("select*from mask where item='{$now1['serial']}'");
      

  5.   

    sql打印出来,执行一下看看是什么错误