date query returning incorrectly
Posted: Fri Feb 02, 2007 3:53 pm
im running this query
and for some reason its returning values from december....what would be the reason for this?
Code: Select all
$sql="SELECT * FROM merchant WHERE user_name = '{$_SESSION['logname']}' AND create_date<=DATE_SUB(CURDATE(), INTERVAL 30 DAY) order by date_recieved";