esentation of the date is a
formatted string, so for all intents and purposes any comparison to a date
field should be using quotes like mentioned already.
--
Sent from my Android phone with K-9 Mail. Please excuse my brevity.
Nathan Rixham wrote:
Richard Quadling wrote: > On 3 March 2011 1
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";
--
2 matches
Mail list logo
