在运行mysql_query(）时，在直接phpmyadmin中运行时出错 - while running mysql_query() getting error working fine in direct phpmyadmin

while running mysql_query() getting error working fine in direct phpmyadmin

当我使用phpmyadmin运行下面的查询时得到结果

SET @rownr=0;
SELECT TVGD.video_id,TVM.Video_Title,@rownr:=@rownr+1 AS `Order`,'0' As Min_Pass_Mark
FROM tbl_video_group_details TVGD,tbl_Video_Master TVM WHERE TVGD.video_id=TVM.id AND TVGD.group_id='23'

但在使用mysql_query((函数

运行时，同样会返回语法错误

mysql_query()不支持多个语句，如1(SET @rownr=0; 2(为此您的查询可以将查询重写为以下

SELECT 
  TVGD.video_id,
  TVM.Video_Title,
  @rownr := @rownr + 1 AS `Order`,
  '0' AS Min_Pass_Mark 
FROM
  tbl_video_group_details TVGD,
  tbl_Video_Master TVM ,
  (SELECT @rownr := 0) t
WHERE TVGD.video_id = TVM.id 
  AND TVGD.group_id = '23'

或者您可以使用mysqli:：multi_query，它确实支持多个语句