Re: something about dates in mysql

On 3 March 2011 10:09, Webforlaget.dk <info@web-forlaget.dk> wrote: > 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 I think that dates in SQL statements need to be in the quotes as they are strings and not integers. So, try ... $sql = "SELECT id,case,startdate,enddate FROM table WHERE startdate<='$thisdate' AND enddate>='$thisdate' ORDER BY startdate"; I'm surprised you don't get an error.... Ah. As it stands, the SQL is something like ... WHERE startdate <= 2010 - 3 - 3 So, probably the actual test that is being executed is .... WHERE startdate <= 2004 Which, for a date stamp will never return anything sensible. Regards, Richard. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY