我想从1_zhgl这个数据表中，按照startnum这个字段分组，统计出各分组下的gold等物资的数量。这个代码好像写的哪里不对。

                                        <?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}