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