Expired Date?

[7724]

Hi Guys,

Wondering if you could help. I have set up a php admin section where you can add ‘events’ into a MySql database and then created a page where all records saved are then pulled out of that database in DATE order on my php template page.

Now this works fine, but I was wondering if anyone knew of a clever bit of php code which I can put on the page that pulls out the data which somehow looks at the current date and if there is an ‘Event’ that has expied and happened the page will not show it?

Many Thanks

Chris

[lilleman]

Hi,

You should be able to filter out expired dates in your SQL query:

SELECT * FROM your_table WHERE date_field >= CURDATE()

(The query above is written for MySQL, but it should give you an idea of how it can be done.)