...

View Full Version : Comparing dates in MySQL



chornbeck
11-10-2011, 12:31 PM
I'm having a problem getting my query to recognize and operate on the date correctly - where am I going wrong here (it pulls all dates, not just the dates less than the variable. The field is a MySQL DATETIME field...


$Date = $_POST['year']."-".$_POST['month']."-".$_POST['day'];

$select = "SELECT * FROM LeadTable WHERE LeadDateTime > $Date";


Help is appreciated! Thanks :)

guelphdad
11-10-2011, 12:55 PM
$Date needs to be enclosed in single quotes.

chornbeck
11-10-2011, 01:04 PM
Ah, yes... Thank you so much - rookie move :)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum