Re: Making several variables into 1 variable

On Tue, Jul 28, 2009 at 10:34 AM, Bob McConnell<rvm@cbord.com> wrote: > From: Miller, Terion > On 7/28/09 8:35 AM, "Ashley Sheridan" <ash@ashleysheridan.co.uk> wrote: > >> $pastDays = strtotime("-30 days"); >> $date = date("d/m/y", $pastDays); >> >> Well I tried and got no results from my query and I know there >> results with date ranges in the last 30 days, I basically need >> to count backward from now() 30 days I thought strtotime() would >> work well..but the fields in the db are varchar not date fields >> they are all formatted the same though 00/00/00: > > If the dates are really stored as varchar, you are doing a lexical > comparison on a field that is meaningless in that context. You will need > to break the string down somewhere and do three separate comparisons. > > Bob McConnell > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > Teri, have you considered making the field a date/ datetime type? You could add the column, then copy the data over with a sql statement casting it to the correct date format you require and then drop the original column -- Bastien Cat, the other other white meat