compare dates

[denoteone]

I was given a csv file with a column for dates. they are in this format:

8/27/2008 12:49

 

i want to pass a variable in my url so that I can search by database so that I return everything from that date on.

 

so the url would be    www.mysite.com?date=08/01/2008

 

can i use that variable to search the date field in my database?

something like

$date = $_GET['date'];

$query = "SELECT *FROM tablename WHERE postDate >= '$date'";  
$result = mysql_query($query)or die (mysql_error());

 

 

[Ken2k7]

Depends on what data type postDate is in. Dates in MySQL are usually in format YYYY-MM-DD H:i:s. You don't need the hours, minutes, seconds, but your date should be in YYYY-MM-DD format. So I don't think MM/DD/YYYY is a valid date format.