On Sun, 2013-10-20 at 00:00 -0400, Bastien wrote: > > Thanks, > > Bastien > > > On Oct 19, 2013, at 10:44 PM, John Taylor-Johnston <jt.johnston@xxxxxxxxxxxxxx> wrote: > > > > I have date strings in my mysql db. yyyy-mm-dd. > > I want to parse to see if the date is greater than november 2011 and less than december 2012. > > > > Is this the right approach? How bad is my syntax? > > > > |function dates_range($todaynow) > > { | > > |$date1=strtotime("2011-11-01"); > > $date2=strtotime("2012-12-31"); > > if (|||($|||||todaynow |>= $date1) and |||||($|||||||todaynow| <= $date2)||) > > || { > > || # do something > > |||| } > > } > > ||| > > Easiest to convert to integers and then compare Yes, I was going to ask, why are you storing your dates as strings? MySQL has a perfectly good DATE type. It's also generally faster comparing dates within a MySQL query than PHP code. Thanks, Ash http://www.ashleysheridan.co.uk