首页 >  PHP频道 > 名师答疑 > 

php编程常遇到的问题

php编程常遇到的问题

作者:yjl 来源:华育国际 时间:2015-02-27 访问次数:1717
php编程常遇到的问题 1、报错误:

php编程常遇到的问题
1、报错误:
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
select user,type,number,sum(price) as aa from reim where number=2 and type=1 and user='aa'
Filename: C:\wamp\www\itsod1\system\database\DB_driver.php
解决方法:加上group by 。查询统计汇总在后面一定要有group by