运算符之间的php查询[关闭]

$eredmeny = mysql_query("SELECT t_nev, sum(t_ertek)
    FROM `termek_mozgas`
    WHERE datum BETWEEN NOW() - INTERVAL 30 DAY AND NOW()
        AND muv_1 = 'Beszerzés'
        OR muv_1 = 'Göngyöleg vissza'
        OR muv_1 = 'Gyártásból bejövő' group by t_nev ");

Hy! Thanks the help! My problem is my query isn't working good.

$eredmeny = mysql_query("SELECT t_nev, sum(t_ertek)
    FROM `termek_mozgas`
    WHERE datum BETWEEN NOW() - INTERVAL 30 DAY AND NOW()
        AND
( muv_1 = 'Beszerzés'
        OR muv_1 = 'Göngyöleg vissza'
        OR muv_1 = 'Gyártásból bejövő'
)
 group by t_nev ");

Change your WHERE condition like below and also use IN operator instead of multiple chained OR condition

   WHERE datum BETWEEN NOW() - INTERVAL 30 DAY AND NOW()
   AND muv_1 IN ('Beszerzés',
                 'Göngyöleg vissza',
                 'Gyártásból bejövő')