Question

ThinkPHP谁帮我看一下SQL查询语句哪里错了？

$db_category=M('category');
$rs_category=$db_category->field('*,concat(path,",",id) as paths,count(explode(",",path)) as deep')->order('paths')->select();
页面输出SQL语句是：SELECT *,concat(path,",",id) as paths,count(explode(",",path)) as deep FROM `db_category` ORDER BY paths
结果是：boolean false

Answer 1

别让sql来帮你做程序计算，这是我写程序的一个思路。sql语句越单纯越好。尽量单表查询。

你可以简单的把sql拿到数据库工具，phpmysqladmin或者navicat等，那边去执行看看是哪里出问题了。