:(

1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rank FROM `tab_game` WHERE `game_status` = 1 AND `recommend_status` = 3 GROUP BY' at line 1 [ SQL语句 ] : SELECT *,min(id) as id,@counter:=@counter+1 AS Rank FROM `tab_game` WHERE `game_status` = 1 AND `recommend_status` = 3 GROUP BY relation_game_id ORDER BY dow_num desc LIMIT 9

错误位置

FILE: /www/wwwroot/1cwan.com/ThinkPHP/Library/Think/Db/Driver.class.php  LINE: 350

TRACE

#0 /www/wwwroot/1cwan.com/ThinkPHP/Library/Think/Db/Driver.class.php(350): E('1064:You have a...')
#1 /www/wwwroot/1cwan.com/ThinkPHP/Library/Think/Db/Driver.class.php(180): Think\Db\Driver->error()
#2 /www/wwwroot/1cwan.com/ThinkPHP/Library/Think/Db/Driver.class.php(946): Think\Db\Driver->query('SELECT *,min(id...', false)
#3 /www/wwwroot/1cwan.com/ThinkPHP/Library/Think/Model.class.php(579): Think\Db\Driver->select(Array)
#4 /www/wwwroot/1cwan.com/Application/Media/Controller/BaseController.class.php(82): Think\Model->select()
#5 /www/wwwroot/1cwan.com/Application/Media/Controller/IndexController.class.php(256): Media\Controller\BaseController->list_data(Array)
#6 /www/wwwroot/1cwan.com/Application/Media/Controller/ArticleController.class.php(180): Media\Controller\IndexController->newgame(3, 'dow_num desc')
#7 [internal function]: Media\Controller\ArticleController->detail('1256', 1)
#8 /www/wwwroot/1cwan.com/ThinkPHP/Library/Think/App.class.php(171): ReflectionMethod->invokeArgs(Object(Media\Controller\ArticleController), Array)
#9 /www/wwwroot/1cwan.com/ThinkPHP/Library/Think/App.class.php(110): Think\App::invokeAction(Object(Media\Controller\ArticleController), 'detail')
#10 /www/wwwroot/1cwan.com/ThinkPHP/Library/Think/App.class.php(204): Think\App::exec()
#11 /www/wwwroot/1cwan.com/ThinkPHP/Library/Think/Think.class.php(120): Think\App::run()
#12 /www/wwwroot/1cwan.com/ThinkPHP/ThinkPHP.php(193): Think\Think::start()
#13 /www/wwwroot/1cwan.com/media.php(48): require('/www/wwwroot/1c...')
#14 {main}