SELECT user_saving_type,SUM(user_saving_num) AS saving_num FROM user_saving WHERE user_saving.user_login_name='1212' AND 1 AND user_saving_day LIKE '2009%' AND saving_num >= 10 AND saving_num <= 100 GROUP BY user_saving_type#1054 - Unknown column 'saving_num' in 'where clause'
SELECT user_saving_type,SUM(user_saving_num) AS saving_num FROM user_saving WHERE user_saving.user_login_name='1212' AND 1 AND user_saving_day LIKE '2009%' AND saving_num >= 10 AND saving_num <= 100 GROUP BY user_saving_type#1054 - Unknown column 'saving_num' in 'where clause'
PHP MYSQL CMS交流群88286077
可能写错了,对比数据库的表检查一下。
SELECT user_saving_type,SUM(user_saving_num) AS saving_num FROM user_saving WHERE user_saving.user_login_name='1212' AND 1 AND user_saving_day LIKE '2009%' AND
GROUP BY user_saving_type
HAVING saving_num >= 10 and saving_num <= 100