[SOLVED] if statement

[sniperscope]

I have an sql query like below.

$New = mysql_query("SELECT id, name, entry_date FROM stuff WHERE display='1' OR display='0' AND display < CURDATE() - INTERVAL 60 DAY ORDER BY dsp_order ASC", $mrs) or die(mysql_error());

but i want to optimize my code and insert if statement into this query but sql always throw me error about if statement. Could some one tell me how can i insert an if statement into this query.

The main logic is: if display=1 show else display=0 then check entry_date if it is 60 days or earlier show it too, if older then 60 days then don't show. Hopefully i could explain well.

[sniperscope]

I found the solution. I made mistake in display < CURDATE

$New = mysql_query("SELECT id, name, entry_date FROM stuff WHERE display='1' OR display='0' AND entry_date > CURDATE() - INTERVAL 60 DAY ORDER BY dsp_order ASC", $mrs) or die(mysql_error());

because it sould entry_date not display. Display column hold ENUM