Question

SQL语句转换成ThinkPHP支持的语句

select count(*),roomid from kg_V_assignclass where status=1 group by roomid 哪位大神知道这段SQL语句转换成TP支持的语句该怎么写啊

Answer 1

$ob=M();
$result=$ob->query('select count(*),roomid from kg_V_assignclass where status=1 group by roomid
');