/**
* 每月循环输出
* return array
*/
function cmd_month_out()
{
$tt = date("n", time());
echo $tt;//这是本月 global $tablename, $pageassigns, $per_page, $np;
global $selectClause, $whereClause, $orderClause, $groupClause;
global $totalRows_month;
for($i=0;$i<=$tt;$i++)
{
$tablename = " shopvisit as s, product as p, user as u ";
$selectClause = " if(sum(s.total), sum(s.total), 0) as total";
$whereClause = " s.type = 1 and s.objId = p.id and u.id = p.userid and p.userid =".(int)$_SESSION['userid']." and (s.dateline (这里的between要怎么写才能每月循环输出呢?) )";
}
dateline的值是以秒的形式存在的
我想实现一个月一个月的数据统计输出 在between里的条件要怎么做才能准确得到每个月的数据呢?
* 每月循环输出
* return array
*/
function cmd_month_out()
{
$tt = date("n", time());
echo $tt;//这是本月 global $tablename, $pageassigns, $per_page, $np;
global $selectClause, $whereClause, $orderClause, $groupClause;
global $totalRows_month;
for($i=0;$i<=$tt;$i++)
{
$tablename = " shopvisit as s, product as p, user as u ";
$selectClause = " if(sum(s.total), sum(s.total), 0) as total";
$whereClause = " s.type = 1 and s.objId = p.id and u.id = p.userid and p.userid =".(int)$_SESSION['userid']." and (s.dateline (这里的between要怎么写才能每月循环输出呢?) )";
}
dateline的值是以秒的形式存在的
我想实现一个月一个月的数据统计输出 在between里的条件要怎么做才能准确得到每个月的数据呢?
每月的总和还是什么?
我计算过一个月的收入:
SELECT DATE_FORMAT(order_date, '%y年%c月') AS set_name,SUM(money_sum) AS turnover FROM $TBL_ORDERS WHERE GROUP BY set_name"
关键是group by set_name 和date_format
希望对你有用