Issue with PHP and dates

[mongoose0031800]

Hello again!

 

How would I go about displaying data from a database query but only showing the results that have a date (in the date field in the db) the is either equal to the current date or in the future? Not show any results in which the date field has a date which is in the past?

 

Thanks!

 

Mongoose

[mongoose0031800]

One thing that may complicate this a little is I am already ordering the query by a field called position which is an integer. Here is my query:

 

$get_shows = mysql_query("SELECT * FROM shows WHERE front_page_featured = '1' ORDER BY position ASC");

[manix]

How about

 

$get_shows = mysql_query("SELECT * FROM shows WHERE front_page_featured = '1' AND `date_field`>='".date('Y-m-d')."' ORDER BY position ASC");

 

You get the idea.

[mongoose0031800]

Great! That worked! Thanks so much!

[jcbones]

You could also use the mysql built in date function to do it as well.

 

$get_shows = mysql_query("SELECT * FROM shows WHERE front_page_featured = '1' AND `date_field`>= CURDATE() ORDER BY position ASC");

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html