query, INTERVAL problem
| From: | nabil | Date: | Tue, 27 May 2003 06:23:26 +0000 |
| Subject: | query, INTERVAL problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28060@lists.php.net to get a copy of this message | ||
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...