[SOLVED] Stop Past Dates

[dmschenk]

I have a simple event list that I would like to improve upon but I'm not exactly sure how to go about.

What I would like to do is when a date passes to yesterday I would like to stop displaying it in my events list.

I would also prefer not to delete its existence but change the field "Online = 1" to "Online = 0" in the database.

 

Is this something I can do or is there a better way?  I'm open to any ideas.

 

Here is my current sql statement:

$sql = "SELECT MONTHNAME(Date), EventDesc, Date, EventLocation, Online
FROM calendar 
WHERE Online = 1
ORDER BY Date";

 

Thanks

Dave

[AndyB]

I'd suggest changing the query to WHERE Date < '$today'.  Today is easily determined by date() function $today = date("Y-m-d").

 

I do hope that Date in your database is a rational date where comparisons are possible.

[bubblegum.anarchy]

SELECT * FROM calendar WHERE Date >= CURRENT_DATE;

[dmschenk]

Yay!!  That was what I needed!! 

 

Many Thanks

Dave