投訴
已解決 sql分組查詢統(tǒng)計數(shù)據(jù)的問題
7 0
我想從1_zhgl這個數(shù)據(jù)表中，按照startnum這個字段分組，統(tǒng)計出各分組下的gold等物資的數(shù)量。這個代碼好像寫的哪里不對。
<?php $query=urlencode('select startnum , count('gold') as c from @#1_zhgl group by startnum');?>
{sql sql='$query' page=1 pagesize=10 urlrule=index.php?page=[page]}
{$t.startnum}-{$t.c}<br>
{/sql}
{$pages}
{$debug}
php技術(shù)不合格
<?php $query=urlencode('select startnum , count(\'gold\') as c from @#1_zhgl group by startnum');?>回復(fù)@薄荷綠
不對 還是報錯
44 <?php $query=urlencode('select startnum , count(\'gold\') as c from @#1_zhgl group by startnum');?>DivisionByZeroError
count('gold')
這是一個錯，其它睡醒再看
<?php $query=urlencode('select startnum from dr_1_zhgl group by startnum;');?>