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

 

[kenrbnsn]

Here's what I use when displaying meeting dates for organizations:

$query = "Select * from meeting_dates where (to_days(date) - to_days(now()) >= 0)";

Note: the field "date" has datatype "date". (Yes, I know that isn't good programming practice)

Ken

 

[predamarcel]

Hi,
why not:

$query = "Select * from meeting_dates where expire_date >= now() " ;

where expire_date is a column of type `date'.

PM

___

http://marcel.rdscv.ro/

____

 

[t5amec]

I have cron job that will take edits the Valid field from 0 to 1 if a gig has passed.

Then my SELECT Code has WHERE valid="0"

Make Sense? I hope so (-: