SYNTAX ERROR WHERE - PHP

Question

I have the following code in php:

$sql = "SELECT * FROM musicas_curtidas 
    GROUP BY musica 
    ORDER BY count(musica) 
    WHERE musica != 'Rádio Turn - Você em primeiro lugar!' AND
    WHERE musica != 'Radio Turn - Não importa o seu estilo! #2' AND
    WHERE musica != 'Radio Turn - Não importa o seu estilo!' AND
    WHERE musica != 'Rádio Turn - Comercial' AND
    WHERE musica != 'Rádio Turn - Na Balada'
    DESC LIMIT 3";    

You’re making a mistake for me:

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 'WHERE musica != 'Radio Turn - You first! ' AND ' at line 4

How can I fix this? I’m a beginner in php.

Answer 1

First of all, PHP has nothing to do with the subject, this is an SQL error.

• The Where clause is one
• The Grouping then
• The Order comes later
• And the limit at the end

If you have any questions when mounting a query, the Manual is a good reference, even if it is not easy in English, have the examples and description of the syntax already in the right order:

https://dev.mysql.com/doc/refman/5.7/en/select.html

Probably could have improved the logic used, but from what he put in the question, these 4 points would be the first to solve.

SELECT *

FROM  musicas_curtidas 

WHERE musica != 'Rádio Turn - Você em primeiro lugar!'
      AND musica != 'Radio Turn - Não importa o seu estilo! #2'
      AND musica != 'Radio Turn - Não importa o seu estilo!'
      AND musica != 'Rádio Turn - Comercial' 
      AND musica != 'Rádio Turn - Na Balada'

GROUP BY musica 

ORDER BY count(musica) DESC

LIMIT 3

Could simplify to

SELECT *

FROM  musicas_curtidas 

WHERE musica NOT IN (
   'Rádio Turn - Você em primeiro lugar!',
   'Radio Turn - Não importa o seu estilo! #2',
   'Radio Turn - Não importa o seu estilo!',
   'Rádio Turn - Comercial',
   'Rádio Turn - Na Balada'
)

GROUP BY musica 

ORDER BY count(musica) DESC

LIMIT 3