I have many problem when I submit (from form) the $due_date , so when I send it as '20030501' it returns with deferent result than '2003-05-01' and that drive me crazy.. my query is : $sql = "SELECT doc_id FROM exams WHERE doc_id='$doc_id' and exam_type_id= '1' and result='PASS' and '$due_date' > (exam_date + INTERVAL 11 MONTH) "; Please help... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
