simple question regarding a mysql query

[jbrill]

hey, im trying to make a simple mysql query

that will only display items that are before, or on the current date.

 

how would i do this?

 

i have a variabel $curdate which is todays date. and i have a date field in the database that is called 'date'.

 

if the 'date' field is before or equal to $curdate, i would like it to show the results, if the 'date' field is after $curdate, ti wont show it.

 

how would i do this?

[only one]

mysql_query("SELECT * FROM `table` WHERE `date` < '$curdate'");