$money = M();
$sql = "SELECT charpool.RoleName,charpool.Level,charpool.Vocation,body.body_Money+bank.Bank_Money AS total FROM charpool,bodyitemstable AS body ,bankitemstable AS bank WHERE charpool.RoleID = body.RoleID AND charpool.RoleID = bank.RoleID ORDER BY total DESC LIMIT 10,10;";
$money_top = $money->query($sql);这条SQL语句可以正常执行，并返回结果。。但是放到THINKPHP里。。就报错
错误位置
FILE: D:\web\htdocs\thinkphp\ThinkPHP\Lib\Core\Db.class.php LINE: 162
TRACE
[13-05-14 11:34:05] D:\web\htdocs\thinkphp\ThinkPHP\Lib\Core\Db.class.php (162) DbMysql->connect()
[13-05-14 11:34:05] D:\web\htdocs\thinkphp\ThinkPHP\Lib\Driver\Db\DbMysql.class.php (94) Db->initConnect()
[13-05-14 11:34:05] D:\web\htdocs\thinkphp\ThinkPHP\Lib\Core\Model.class.php (1097) DbMysql->query(SELECT charpool.RoleName,charpool.Level,charpool.Vocation,body.body_Money+bank.Bank_Money AS total FROM charpool,bodyitemstable AS body ,bankitemstable AS bank WHERE charpool.RoleID = body.RoleID AND charpool.RoleID = bank.RoleID ORDER BY total DESC LIMIT 10,10;)
[13-05-14 11:34:05] D:\web\htdocs\thinkphp\Home\Lib\Action\IndexAction.class.php (15) Model->query(SELECT charpool.RoleName,charpool.Level,charpool.Vocation,body.body_Money+bank.Bank_Money AS total FROM charpool,bodyitemstable AS body ,bankitemstable AS bank WHERE charpool.RoleID = body.RoleID AND charpool.RoleID = bank.RoleID ORDER BY total DESC LIMIT 10,10;)
[13-05-14 11:34:05] () IndexAction->index()
[13-05-14 11:34:05] D:\web\htdocs\thinkphp\ThinkPHP\Lib\Core\App.class.php (171) ReflectionMethod->invoke()
[13-05-14 11:34:05] D:\web\htdocs\thinkphp\ThinkPHP\Lib\Core\App.class.php (207) App::exec()
[13-05-14 11:34:05] D:\web\htdocs\thinkphp\ThinkPHP\Lib\Core\Think.class.php (39) App::run()
[13-05-14 11:34:05] D:\web\htdocs\thinkphp\ThinkPHP\Common\runtime.php (242) Think::start()
[13-05-14 11:34:05] D:\web\htdocs\thinkphp\ThinkPHP\ThinkPHP.php (30) require(D:\web\htdocs\thinkphp\ThinkPHP\Common\runtime.php)
[13-05-14 11:34:05] D:\web\htdocs\thinkphp\index.php (5) require(D:\web\htdocs\thinkphp\ThinkPHP\ThinkPHP.php) 最佳答案
