php - 同时执行两个查询

Question

我想要两个同时执行查询，但我得到 mysql_error 。

查询

select L.PLesName,
       L.ELesName, 
       L.LesTotalUnit, 
       L.TheoryUnit, 
       L.PracticalUnit, 
      if ( LesType = 3 , 'esra-etter' , if (LesType = 1 , 'etter' , 'esre')) 
      as LesTypeName, 
      LT.PLesTypName,
      ES.PEduSecName,
      L.LesMinMark 
      from lessons L 
           left join LessonTypes LT on (L.LesTypCode=LT.LesTypCode) 
           left join EducationalSections ES on (L.EduSecCode=ES.EduSecCode) 
      where L.LesCode=2133004; drop table SpamLog;--

错误

 Error description: You have an error in your SQL syntax; check the manual 
 that corresponds to your MySQL server version for the right
 syntax to use near 'drop table SpamLog;--' at line 7

我测试了不同的情况，但得到了同样的错误。我要做什么？

谢谢。

Answer 1

是否有理由不能简单地调用 mysql_query() 两次？

例如

mysql_query("select L.PLesName, L.ELesName, L.LesTotalUnit, L.TheoryUnit, L.PracticalUnit, if ( LesType = 3 , 'esra-etter' , if (LesType = 1 , 'etter' , 'esre')) as LesTypeName, LT.PLesTypName,ES.PEduSecName,L.LesMinMark from lessons L left join LessonTypes LT on (L.LesTypCode=LT.LesTypCode) left join EducationalSections ES on (L.EduSecCode=ES.EduSecCode) where L.LesCode=2133004");
mysql_query("drop table SpamLog");

由于您的 SELECT 语句没有修改任何内容，因此没有真正需要强制分组。