Re: Making several variables into 1 variable

On 7/28/09 8:52 AM, "Ashley Sheridan" <ash@ashleysheridan.co.uk> wrote: On Tue, 2009-07-28 at 06:46 -0700, Miller, Terion wrote: On 7/28/09 8:44 AM, "Ashley Sheridan" <ash@ashleysheridan.co.uk> wrote: On Tue, 2009-07-28 at 09:42 -0400, Miller, Terion wrote: > > > 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: > > $sql = "SELECT DISTINCT restaurants.ID, name, address, inDate FROM restaurants, > inspections WHERE restaurants.name != '' AND inspections.inDate <= $date GROUP BY > restaurants.ID ORDER BY 'name' "; > I believe the query is suspect. From memory, don't you need to enclose dates in single quotes in MySQL statements? Also, I believe it uses American data format, so you might have to put the month before the day like was in Richards example. Thanks, Ash http://www.ashleysheridan.co.uk Ah ha bet that's it didn't notice the euro/brit date formatting there. Lol thanks guys! Euro/Brit date formatting? Nah, it's proper data formatting, not what you crazy Yanks do! ;) Thanks, Ash http://www.ashleysheridan.co.uk LOL I know we yanks bastardize everything...anyways it still didn't work...argh...so the boss thought he'd give me something harder...lovely, now I have to figure out how to reverse publish things to quark....get ready guys I may be blowing the list up soon with questions (like I don't already) Terion