help with date/time - determining expiry date

[adammc]

Hi guys,

I was hoping for some help if possible?

I need to find a way to mark entries in the MYSQL DB as expired once the expired date has passed.

I plan on putting some code on the top of my front page so it can make this check whenever my site is loaded.

example of data in expiry_date column
2006-09-20 13:28:10

I am using a function to get the current date (it is stored in $currentdatetime variable), it is oputputting the date as:
2006-09-27 14:29:08

Would I use '<' Less than ??

// run the query
$SQL = " UPDATE postings SET status = 'expired' WHERE expiry_date < LESS THAN ?? $currentdatetime"; 

[Fumigator]

As long as column expiry_date is of data type "date", "timestamp", or "datetime" then that works.

[adammc]

Hi there,
thanks for the reply

So this should work?

WHERE expiry_date <  $currentdatetime 

[adammc]

Whoo Hoo!! It works

$SQL = " UPDATE postings SET status = 'expired' WHERE expiry_date < '$currentdatetime3'"; 

Thanks for the kick in the *** to try it myself... I swear, i just wont learn

[Fumigator]

MySQL has its own current date function, no need to get the current date from PHP and pass it into your query. Just use curdate(). That of course assumes your date column is a data type "date", "timestamp", or "datetime", which you haven't said one way or the other.

[adammc]

I ma using my own function because the timezone difference.