CODEWITHSUNDEEP
phpmysql
user1212132
user1212132

Reputation: 23

Execute two query at the same time

I want two execute to query at the same time but I get mysql_error .

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; drop table SpamLog;--

Error

 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

I test diffrence cases but I get same error. What am I going to do ?

Thanks.

Upvotes: 0

Views: 245

Answers (1)

Amber
Amber

Reputation: 526613

Is there a reason you can't simply call mysql_query() twice?

e.g.

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");

Since your SELECT statement isn't modifying anything, there's no real need to enforce grouping.

Upvotes: 1

Related Questions