Checking if date passed?

[NathanDTaylor]

So, basically, I have it set up so that banned users are in a table in the database called "bans". The lift date is formatted like such.. "02/14/2013 14:06AM"

How can I make it so that if the date is passed, it removes the row from the table?

 

Like how do I set up

if($lift_date >= $c_date){
//remove
}

when using the time of day too?

Edited February 14, 2013 by NathanDTaylor

[doddsey_65]

if (strtotime($lift_date) < time())
{
    //remove ban
}

[NathanDTaylor]

if (strtotime($lift_date) < time())
{
//remove ban
}

 

And that will work with the current format I am using?

[doddsey_65]

Sorry, You would need to remove the AM/PM from the date that you are using

[NathanDTaylor]

Sorry, You would need to remove the AM/PM from the date that you are using

 

Oh, stupid me. I have a 24hour format and I put AM/PM on the end XD

[NathanDTaylor]

Sorry, You would need to remove the AM/PM from the date that you are using

 

if I set the ban life date to 2/14/2013 8:45, it doesn't lift the bad. It says that 14:28 is earlier than 8:45?

[Barand]

The pains of not using correct datetime data types.

 

You could use STR_TO_DATE() in your query to convert it to a DATETIME

[NathanDTaylor]

The pains of not using correct datetime data types.

 

You could use STR_TO_DATE() in your query to convert it to a DATETIME

 

In the MySQL Query? Because "STR_TO_DATE()" is not a valid PHP function

[Barand]

That's why I said "in your query" . EG

 

SELECT * FROM mytable
WHERE STR_TO_DATE(lift_date, '%m/%d/%Y %H:%i') < NOW()

[NathanDTaylor]

That's why I said "in your query" . EG

 

SELECT * FROM mytable
WHERE STR_TO_DATE(lift_date, '%m/%d/%Y %H:%i') < NOW()

 

okay, thanks