something about dates in mysql
| From: | Webforlaget.dk | Date: | Thu, 03 Mar 2011 10:09:19 +0000 |
| Subject: | something about dates in mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-311620@lists.php.net to get a copy of this message | ||
I need help to know Why this dont work ?
-------------------------------------------------------------
$thisdate =date("Y-m-d",mktime(0,0,0,$mth, $day, $year));
$sql = "SELECT id,case,startdate,enddate FROM table WHERE startdate<=$thisdate AND
enddate>=$thisdate ORDER BY startdate";
-------------------------------------------------------------
The result should be an array whith open cases at $thisdate, but nothing appear.
Is it something about dates in mysql ?
Thanks for any advice.
Best regards,
Venlige hilsner
Rolf Brejner