MySQL Select By Time Difference

[ShoeLace1291]

I have a table called "events" that I want to gather data from.  The events that I want are ones that haven't happend yet.  There is a column for date that contains the unix timestamp string.  How would I select the rows with dates greater than the current date?

[s0c0]

Try

 

SELECT * FROM events WHERE event_date > CURRENT_DATE()

 

This is a very basic question, you should really go grab a book on PHP/MySQL if you're going to be programming a lot.

*edit*

I just noticed you're using a unixtimestamp.  You'll need to look up how to convert the current_date into a unixtimestamp.  There should be a mysql function that does this, you can use PHP as well.  Beyond that the SQL I gave you will work, just figure it out.