Out Of Date? How to use it?

[danielhalawi]

I'm developing a website which has competitions, I'm storing the competition and data in a database, and I have a field which has an enddate in it. How do I display all the competitions which are currently valid and the date is before the enddate field.

For example if the enddate happened to be 2003-01-09 16-29-00 and the time had pass how do I make sure that this competition is not displayed rather than having to delete from the database?

thanx

[gottes_tod]

maybe next sql will help you

select * from competitions where ... and date < $enddate

where filed date and $enddate - date in unix timestamp format..

[gottes_tod]

maybe sql:

select * from competitions  ... and where date < $enddate

where field date and variable $enddate are date in unix timestamp format