在php中的一个查询中定义变量并运行查询[关闭]

Question

this is my query it's work in MySQL, but I don't know how to do it in php.

set @rank = 0; update tbl a join (select id, @rank:=@rank+1 as rank from tbl order by id) b on a.id = b.id set a.id = b.rank;

any idea? thank you

Answer 1

This is two queries.

If you used mysql extension, you should run two queries on two different mysql_query(); like this:

mysql_query("set @rank = 0;");
mysql_query("update tbl a join (select id, @rank:=@rank+1 as rank from tbl order by id) b
on a.id = b.id set a.id = b.rank;");

It must work