一个php查询以后进行累加的问题

这是我的代码第一个sql是可以累加的，后面的好像不行不知道是什么原因希望大家知道的能给小弟指出来

<?php
$conn=mysql_connect("localhost","root","admin") or die("数据库连接失败");
mysql_select_db('flex') or die('选择数据库失败');
$sql="select SUM(dianshu) as amount from dian_message where user='周莎'";
$query=mysql_query($sql) or die('sql执行错误');
$sql1="select SUM(dianshu) as teng from dian_message where user='程腾传'";
$query1=mysql_query($sql1) or die('sql执行错误');
$sql2="select SUM(dianshu) as tang from dian_message where user='唐乐'";
$query2=mysql_query($sql2) or die('sql执行错误');
header('Content-type: text/xml');
echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
echo "<datas>";
while($row=mysql_fetch_array($query))
{
 echo "<data>";
 echo "<user>".周莎."</user>";
 echo "<dianshu>".$row[amount]."</dianshu>";
 echo "</data>";
}
while($row1=mysql_fetch_array($query1))
{
 echo "<data>";
 echo "<user>".程腾传."</user>";
 echo "<dianshu>".$row[amount]."</dianshu>";
 echo "</data>";
}
echo "</datas>";
?>

 

参数写错了应该是$row1[amount]  $row后少了个1

看起来也没错，不好查，发显示错误的图片来看看

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息！