Question

php sql语句这样写，哪里错了，去了order by就能出来了结果，加上就什么也出不来了

$dsql->query("rowa",'SELECT * FROM jiehun_archives AS a, jiehun_arctype AS b, jiehun_addon19 AS c WHERE a.typeid = b.id AND c.typeid = a.typeid AND a.id = c.aid and b.reid='.$value. 'order by c.aid desc LIMT 0,8');

Answer 1

b.reid='.$value. 'order

^ 空格应该在单引号后面吧？
limit拼写也错了

建议以后这样写
"select ... b.reid='{$value}' order by..."

Answer 2

mysql?

简单看了眼 limit，写错了

Answer 3

因为查询出来的结果没有c表的内容

Answer 4

。。。limit 不是limt