I am designing a dynamic webpage that uses a SQL DB to call events... It works in the fact that it calls and displays all the events. Now I am trying to filter it so it only shows the events that are in the future. I have put a PHP clock on the site and can call the current time/date in variable and put it where ever. My thought was to then use an IF statement that would compare event.eventEnd (field of ending time of event in YYYY-MM-DD 00:00:00 format) to $gDate (current Time/Date in UNIX Seconds format). I also selected the event.eventEnd from the DB in UNIX_TIMESTAMP so they would be in the same format. I can display both numbers on the page with the repeating do {} loop but I can't figure out where and how to put the IF statement...
That sir worked great... I didn't want anything in the past so I took the INTERVAL down to 0 DAYS and it only calls future events... Thanks I was banging my head for what I'm certain people thought was an easy answer...