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
