Q:

How to have more than one condition for data recall

I have a table in my MySQL database that looks like the following
banner
--------
 id  : bigint(20)
name : varchar(75)
type : set('news','event')
link : bigint(20)
when : int(10)

What I want to do is I want to be able to recall all the rows with the type of "news"
but I only want to recall all of the rows with the type of "event" where 'when > time()'
or basically any event that takes place in the future
RECAP: 

recall all NEWS items
recall only EVENTS that happen in the future

I'm running the SQL query using PHP as the scripting language.
Thanks all

A:

i had tried something akin to what Lukasz Lysik suggested but was still getting past events.
i think the following solved it
SELECT * 
FROM `banner` 
WHERE IF(`type` = 'event', `when` > NOW(), 1) 
ORDER BY `when` DESC

