show records greater then today's date help

[conan318]

still shows all records in the database... any idea how i go about this?

$date= date('y-m-d');
$query=mysql_query("SELECT * FROM listing WHERE date >= $date") or die (mysql_error());

 

[Drummin]

$date= date('y-m-d');
$query=mysql_query("SELECT * FROM listing WHERE date>='$date'") or die (mysql_error());

[conan318]

iam using the date field with the date being displayed as 2011-09-13

after checking the field is called expire_date.

but still no luck

$date= date('y-m-d');
$query=mysql_query("SELECT * FROM listing WHERE expire_date>='$date'") or die (mysql_error());

 

 

[Drummin]

And I assume you have records in your listing table with the expire_date greater than 2011-09-13.  I once had an issue with using underscore in a field name where it wasn't picking up the second half of the name.  You might try changing the field name to `expiredate`and see how that works.  Hey, it's a thought.

[PFMaBiSmAd]

The date() format string should be 'Y-m-d'

[conan318]

topic solved once again thanks guys

$date= date('Y-m-d');
$query=mysql_query("SELECT * FROM listing WHERE expiredate>='$date'") or die (mysql_error());