PHP怎么执行有带分号的MYSQL语句?我想要搞一个排名的字段. SET @mycnt =0;
SELECT (@mycnt := @mycnt +1) AS rankings,uid,sum() AS s FROM bo_log GROUP BY uid ORDER BY s DESC
但是这样的话再MYSQL里面可以执行. 但是在PHP里的mysql_query就不能用了.. 如果把分号去掉在MYSQL里面不能用了rankings会变成空值
SELECT (@mycnt := @mycnt +1) AS rankings,uid,sum() AS s FROM bo_log GROUP BY uid ORDER BY s DESC
但是这样的话再MYSQL里面可以执行. 但是在PHP里的mysql_query就不能用了.. 如果把分号去掉在MYSQL里面不能用了rankings会变成空值
学习 了
嗯,csdn的搜索不行你仿照这个写select @a:=@a+1, id
from k,
(select @a:=2 ) tmp
order by id
;
$rs = mysql_query("SELECT (@mycnt := @mycnt +1) AS rankings,uid,sum() AS s FROM bo_log GROUP BY uid ORDER BY s DESC");
但是这样子最后的出来的rankings是NULL
SELECT (@mycnt := @mycnt +1) AS rankings,uid,sum() AS s
FROM bo_log, (select @mycnt:=0 ) tmp
GROUP BY uid
ORDER BY s DESC另,你真的不打算用存储过程和mysqli_multi_query ?