1.我给你的SQL代码应该是正确的,我不知道你是想求每个月中每一周的和还是求所有的一周,二周...的和.
我给你的代码是第一种,如果要求第二种,就改成:
SELECT WEEKDAY(date),
sum(pv),sum(ip),sum(add)
FROM webcount group by WEEKDAY(date)
文件listclass.php
<?
$action=$_GET['action'];
include("conn.php");
//SQL语句
$sql="select * from class order by id desc";
//执行SQL语句
$result=mysql_query($sql);
?>
</p>
<table width="335" height="52" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" height="25">分类名</td>
</tr>
<?
//循环输出记录
while($row=mysql_fetch_row($result))
{
?>
<tr>
<td align="center" height="25"><a href="listcou.php?class_id=<?=$row[0]?>&action=<?=$action?>"><?=$row[1]?></a></td>
</tr>
<?
}
mysql_free_result($result);
mysql_close($conn);
?>
</table>
文件listcou.php
<?
$class_id=$_GET['class_id'];
$action=$_GET['action'];
include("conn.php");
//显示列表///////////////////////////////////////////////////////
$class_id=$_GET['class_id'];
//SQL语句
if ($action=="day")
{
$sql="select * from coulist where class_id = '$class_id' order by id desc";
}
elseif ($action=="month")
{
$sql="SELECT YEAR(c_date),DAYOFMONTH(c_date),sum(c_pv),sum(c_ip),sum(c_add) FROM coulist where class_id = '$class_id' group by YEAR(c_date),DAYOFMONTH(c_date)";
}
elseif ($action=="week")
{
$sql="SELECT YEAR(c_date),DAYOFMONTH(c_date),WEEKDAY(c_date),sum(c_pv),sum(c_ip),sum(c_add) FROM coulist where class_id = '$class_id' group by YEAR(c_date),DAYOFMONTH(c_date),WEEKDAY(c_date)";
}
所以语句如下:
星期:
SELECT YEAR(date),DAYOFMONTH(date),WEEKDAY(date),
sum(pv),sum(ip),sum(add)
FROM webcount group by YEAR(date),DAYOFMONTH(date),WEEKDAY(date)
月:
SELECT YEAR(date),DAYOFMONTH(date,
sum(pv),sum(ip),sum(add)
FROM webcount group by YEAR(date),DAYOFMONTH(date)