php query between operator

Question

$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.

What do you mean by "isn't working good"? Do you get the desired result - if not, what is it? It is hard to help you without knowing what is wrong — kero, Jun 16 '14 at 22:03
Consider braces to ensure that your combination of AND or OR criteria are being evaluated correctly — Mark Baker, Jun 16 '14 at 22:03
`mysql_query` has been deprecated for a while now. Stop using it, or stop expecting help with using it. — cHao, Jun 17 '14 at 03:37

score 1 · Answer 1 · answered Jun 16 '14 at 22:12

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ő')

score 0 · Accepted Answer · answered Jun 16 '14 at 22:07

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

php query between operator

2 Answers2