求高手解决下面的问题 select goodssize,sum(if(goodscolor='黑',goodsnum,0)) as 黑,sum(if(goodscolor='白',goodsnum,0)) as 白,sum(goodsnum) as 合计 from goodsnum group by goodssize 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 insert into goodsum ( goodscolor , goodssize, goodsnum ) values ( 黑 ,s, 2 );insert into goodsum ( goodscolor , goodssize, goodsnum ) values ( 黑 ,m, 0 );insert into goodsum ( goodscolor , goodssize, goodsnum ) values ( 白 ,s, 7 );insert into goodsum ( goodscolor , goodssize, goodsnum ) values ( 白 ,m, 13 );这样不行吗? insert into goodsum ( goodscolor , goodssize, goodsnum ) values ( 黑 ,s, 2 );insert into goodsum ( goodscolor , goodssize, goodsnum ) values ( 黑 ,m, 0 );insert into goodsum ( goodscolor , goodssize, goodsnum ) values ( 白 ,s, 5 );insert into goodsum ( goodscolor , goodssize, goodsnum ) values ( 白 ,m, 8 );这样不行吗? $sql = "select goodscolor from goodsnum group by goodscolor order by goodscolor";$result = mysql_query($sql);echo "<tr>";while($dbRow = mysql_fetch_object($result)){ echo "<td>$dbRow->goodscolor</td>";}echo "</tr>";$sql = "select goodssize from goodsnum group by goodssize order by goodssize";$result = mysql_query($sql);while($dbRow = mysql_fetch_object($result)){ echo "<tr>"; $sql = "select goodsnum from goodsnum where goodssize='$dbRw->goodssize' order by goodscolor"; $res = mysql_query($sql); while($dbRow = mysql_fetch_object($res)) { echo "<td>$dbRow->goodscolor</td>"; } echo "</tr>";} 忘加合计了-----====----echo "<table>";$sql = "select goodscolor from goodsnum group by goodscolor order by goodscolor";$result = mysql_query($sql);echo "<tr>";while($dbRow = mysql_fetch_object($result)){ echo "<td>$dbRow->goodscolor</td>";}echo "<td>合计</td></tr>";$sql = "select goodssize from goodsnum group by goodssize order by goodssize";$result = mysql_query($sql);$total = 0;while($dbRow = mysql_fetch_object($result)){ $sum = 0; echo "<tr>"; $sql = "select goodsnum from goodsnum where goodssize='$dbRow->goodssize' order by goodscolor"; $res = mysql_query($sql); while($dbRow = mysql_fetch_object($res)) { echo "<td>$dbRow->goodsnum</td>"; $sum = $sum + $dbRow->goodsnum; } $total = $total + $sum; echo "<td>$sum</td>"; echo "</tr>";}$sql = "select goodscolor from goodsnum group by goodscolor order by goodscolor";$result = mysql_query($sql);while($dbRow = mysql_fetch_object($result)){ $sql = "select count(goodsnum) from goodsnum where goodscolor='$dbRow->goodscolor'"; $res = mysql_query($sql); echo "<td>".mysql_result($res, 0, 'count(goodsnum)')."</td>";}echo "</table>"; 关于图片在服务器存储的问题 action="http://www.x-sk.com/?p=34&a=creat" 关于php开发的几个难点,都是实际碰到的,希望对你有帮助 请问各位高手用PHP+MySQL开发这系统行嘛? 请教PHP循环获取分组checkbox的值 请问一个下拉菜单的问题。 小妹求救啊!多文件上传,怎么样从数组中取出数据。 SQL语句的问题 我的系统不支持图象???怎么办,急急 鼠标一移动到上面。就显示某种提示! 以前用得好好的程序,现在连不上数据库了。 如何对mysql数据库进行并发处理?
insert into goodsum ( goodscolor , goodssize, goodsnum ) values ( 黑 ,m, 0 );
insert into goodsum ( goodscolor , goodssize, goodsnum ) values ( 白 ,s, 7 );
insert into goodsum ( goodscolor , goodssize, goodsnum ) values ( 白 ,m, 13 );这样不行吗?
insert into goodsum ( goodscolor , goodssize, goodsnum ) values ( 黑 ,m, 0 );
insert into goodsum ( goodscolor , goodssize, goodsnum ) values ( 白 ,s, 5 );
insert into goodsum ( goodscolor , goodssize, goodsnum ) values ( 白 ,m, 8 );这样不行吗?
$result = mysql_query($sql);
echo "<tr>";
while($dbRow = mysql_fetch_object($result))
{
echo "<td>$dbRow->goodscolor</td>";
}
echo "</tr>";
$sql = "select goodssize from goodsnum group by goodssize order by goodssize";
$result = mysql_query($sql);
while($dbRow = mysql_fetch_object($result))
{
echo "<tr>";
$sql = "select goodsnum from goodsnum where goodssize='$dbRw->goodssize' order by goodscolor";
$res = mysql_query($sql);
while($dbRow = mysql_fetch_object($res))
{
echo "<td>$dbRow->goodscolor</td>";
}
echo "</tr>";
}
----====----
echo "<table>";
$sql = "select goodscolor from goodsnum group by goodscolor order by goodscolor";
$result = mysql_query($sql);
echo "<tr>";
while($dbRow = mysql_fetch_object($result))
{
echo "<td>$dbRow->goodscolor</td>";
}
echo "<td>合计</td></tr>";
$sql = "select goodssize from goodsnum group by goodssize order by goodssize";
$result = mysql_query($sql);
$total = 0;
while($dbRow = mysql_fetch_object($result))
{
$sum = 0;
echo "<tr>";
$sql = "select goodsnum from goodsnum where goodssize='$dbRow->goodssize' order by goodscolor";
$res = mysql_query($sql);
while($dbRow = mysql_fetch_object($res))
{
echo "<td>$dbRow->goodsnum</td>";
$sum = $sum + $dbRow->goodsnum;
}
$total = $total + $sum;
echo "<td>$sum</td>";
echo "</tr>";
}
$sql = "select goodscolor from goodsnum group by goodscolor order by goodscolor";
$result = mysql_query($sql);
while($dbRow = mysql_fetch_object($result))
{
$sql = "select count(goodsnum) from goodsnum where goodscolor='$dbRow->goodscolor'";
$res = mysql_query($sql);
echo "<td>".mysql_result($res, 0, 'count(goodsnum)')."</td>";
}
echo "</table>";