SQL statement not running in php script

Question

The sql runs perfectly in mysql, but when entered in a query in php, it genetrates a HTTP 500, not sure why?

$sel_query="SELECT 
    Class_List.Class_List_id,
    Class_List.class_id, 
    count(Class_List.user_id) 
  AS 
    Total,
    User_Accounts_.user_id, 
    User_Accounts_.firstname, 
    User_Accounts_.lastname, 
    User_Accounts_.ALN, 
    User_Accounts_.EAL, 
    count(if(User_Accounts_.Gender="Male",1,NULL)) 'Male', 
    count(if(User_Accounts_.Gender="Female",1,NULL)) 'Female', 
    count(if(User_Accounts_.Gender="ALN",1,NULL)) 'ALN', 
    count(if(User_Accounts_.Gender="EAL",1,NULL)) 'EAL' 
FROM Class_List, User_Accounts_ 
WHERE User_Accounts_.user_id=Class_List.user_id AND Class_List.class_id=1";

"Male" , "Female" , "ALN" , "EAL" ... instead of double quote use single quote — shirshak007
– shirshak007, Commented Dec 3, 2021 at 10:13
Hello, I was edit to make your SQL more readable. No syntax change just add new line and indent to be more easy to read. — vee
– vee, Commented Dec 3, 2021 at 10:17
Shirshaks comment tells you the solution, however I would advise you to take a look at the error log file and try to understand the error. In this case you open the string with double quotes, and use double quotes in the string. You need to escape the double quotes or use single quotes. — Gert B.
– Gert B., Commented Dec 3, 2021 at 10:20

thchp · Accepted Answer · 2021-12-03 10:12:27Z

1

Escape quotes.

$sel_query="
SELECT Class_List.Class_List_id,Class_List.class_id, count(Class_List.user_id) AS Total,User_Accounts_.user_id, User_Accounts_.firstname, User_Accounts_.lastname, User_Accounts_.ALN, User_Accounts_.EAL, count(if(User_Accounts_.Gender=\"Male\",1,NULL)) 'Male', count(if(User_Accounts_.Gender=\"Female\",1,NULL)) 'Female', count(if(User_Accounts_.Gender=\"ALN\",1,NULL)) 'ALN', count(if(User_Accounts_.Gender=\"EAL\",1,NULL)) 'EAL' 
FROM Class_List, User_Accounts_ 
WHERE User_Accounts_.user_id=Class_List.user_id AND Class_List.class_id=1
";

answered Dec 3, 2021 at 10:12

thchp

2,4741 gold badge22 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL statement not running in php script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related