Re: Making several variables into 1 variable

On Tue, Jul 28, 2009 at 10:43 AM, Miller, Terion<tmiller@springfi.gannett.com> wrote: > > > > On 7/28/09 9:40 AM, "Bastien Koert" <phpster@gmail.com> wrote: > > 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 > > I don't think I can this data is being pulled from our county health site, so it comes in > how they put it on their page (scraping here)  and I'm grabbing it using regex. (and this is > totally public info so it's legit-my employer tells me) > > > Yep, if you are not in control of the data and are just screenscraping a site, then you don't have too many choices. -- Bastien Cat, the other other white meat