<?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;
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;
query1=mysql_query("select*from mask where item={$now1['serial']}");
if ($query1) {不能出来结果 为什么?谢谢了
看提示什么错误。
$query1=mysql_query("select * from mask where item='".$now1['serial']}."'")
将$query1打出来,再将其帖到mysql中看看能否运行成功;