help with mysql query and php code

[h2m]

I am building a simple announcement or news database and script. I have 2 dates the date the announcement was entered and the date when it is done.

I was trying to do something like

$todays_date="2002-11-01";
$query = "select * from announcement WHERE end_date >= $todays_date;"; 

When I run my query everythign is returned, not just the announcements that end after todays date.

In my database the field end_date holds the date like this "2002-10-25" depending the the date set.

How do I go about getting this to work?

[benbox]

does PHP/mySQL actually recognise 2002-10-25 as a date or just a mixed number and characters string? ... i.e. duz it recognise 2002-10-27 to be after 2002-10-25?

[Lars_Berg]

query = "select * from announcement WHERE end_date >= '" . $todays_date ."'";

• stands for subtraction

2002-11-1 = 1990

as dates are stored internally as numerical values, (sloppy) mysql allows the query. The value stored is the number of seconds since some epoch so no wonder you get all rows.

[dawson1323]

EDIT: date should be:

date ('Y-n-j');

you should try something like this:

$todays_date = date('n/j/y');
$query = mysql_query ("select * from announcement WHERE end_date >= $todays_date");

-D

[dawson1323]

One more piece of input. This statement:

end_date >= $todays_date

Might need to be changed to:

end_date <= $todays_date

The first states that end_date is greater than or equal to $todays_date

The second states that end_date is less than or equal to $todays_date

-D