Only display if date is after current date (Date: YYYY - MM - DD)

[Clarkie]

Hey,

 

I'm using a script which allows you to click on a calendar to select the date to submit to the database.

 

The date is submitted like this: 2014-02-08

 

Is there a really simple way to prevent rows showing if the date is in the past?

 

Something like this:

if($currentdate < 2014-02-08 || $currentdate == 2014-02-08) {

 

}

 

Thanks very much,

Jack

[samshel]

Check strtotime function.

It converts a date into Unix timestamp.

 

You can convert both current date and date to  compare in unix timestamp [which is in seconds] and do a <= comparison.

[Pikachu2000]

Your question isn't very clear, but maybe something like this is what you mean?

 

SELECT field FROM table WHERE date >= CURDATE()

[Clarkie]

Check strtotime function.

It converts a date into Unix timestamp.

 

You can convert both current date and date to  compare in unix timestamp [which is in seconds] and do a <= comparison.

Thanks that's exactly what I need!

 

Your question isn't very clear, but maybe something like this is what you mean?

 

SELECT field FROM table WHERE date >= CURDATE()

Thanks to you also I'll use this to actually get the right rows from the db.