Bastien Koert wrote:
> On Tue, Jul 28, 2009 at 10:43 AM, Miller,
> Terion wrote:
>>
>>
>> On 7/28/09 9:40 AM, "Bastien Koert" wrote:
>>
>> On Tue, Jul 28, 2009 at 10:34 AM, Bob McConnell wrote:
>>> From: Miller, Terion
>>> On 7/28/09 8:35 AM, "Ashley Sheridan" wrote:
>>>
$pastDays = strtotim
On Tue, Jul 28, 2009 at 10:43 AM, Miller,
Terion wrote:
>
>
>
> On 7/28/09 9:40 AM, "Bastien Koert" wrote:
>
> On Tue, Jul 28, 2009 at 10:34 AM, Bob McConnell wrote:
>> From: Miller, Terion
>> On 7/28/09 8:35 AM, "Ashley Sheridan" wrote:
>>
>>> $pastDays = strtotime("-30 days");
>>> $date = date(
On Tue, Jul 28, 2009 at 10:40 AM, Miller,
Terion wrote:
>
>
>
> <,snip>
>>
>
> You can also do this right within MySQL without needing to create a
> variable. This should work:
> $sql = "SELECT DISTINCT restaurants.ID, name, address, inDate FROM
> restaurants, inspections WHERE restaurants.name !=
On 7/28/09 9:40 AM, "Bastien Koert" wrote:
On Tue, Jul 28, 2009 at 10:34 AM, Bob McConnell wrote:
> From: Miller, Terion
> On 7/28/09 8:35 AM, "Ashley Sheridan" wrote:
>
>> $pastDays = strtotime("-30 days");
>> $date = date("d/m/y", $pastDays);
>>
>> Well I tried and got no results from my qu
On Tue, Jul 28, 2009 at 10:34 AM, Bob McConnell wrote:
> From: Miller, Terion
> On 7/28/09 8:35 AM, "Ashley Sheridan" 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
<,snip>
>
You can also do this right within MySQL without needing to create a
variable. This should work:
$sql = "SELECT DISTINCT restaurants.ID, name, address, inDate FROM
restaurants, inspections WHERE restaurants.name != '' AND
datediff(curdate(),inspections.inDate)>=30 GROUP BY restaurants
From: Miller, Terion
On 7/28/09 8:35 AM, "Ashley Sheridan" 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
On Jul 28, 2009, at 9:55 AM, Miller, Terion wrote:
On 7/28/09 8:52 AM, "Ashley Sheridan"
wrote:
On Tue, 2009-07-28 at 06:46 -0700, Miller, Terion wrote:
On 7/28/09 8:44 AM, "Ashley Sheridan"
wrote:
On Tue, 2009-07-28 at 09:42 -0400, Miller, Terion wrote:
On 7/28/09 8:35 AM, "
> On Tue, 2009-07-28 at 09:42 -0400, Miller, Terion wrote:
> >
> >
> > On 7/28/09 8:35 AM, "Ashley Sheridan" 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 ran
On 7/28/09 8:52 AM, "Ashley Sheridan" wrote:
On Tue, 2009-07-28 at 06:46 -0700, Miller, Terion wrote:
On 7/28/09 8:44 AM, "Ashley Sheridan" wrote:
On Tue, 2009-07-28 at 09:42 -0400, Miller, Terion wrote:
>
>
> On 7/28/09 8:35 AM, "Ashley Sheridan" wrote:
>
> $pastDays = strtotime("-30 da
On Tue, Jul 28, 2009 at 9:46 AM, Miller,
Terion wrote:
>
>
>
> On 7/28/09 8:44 AM, "Ashley Sheridan" wrote:
>
> On Tue, 2009-07-28 at 09:42 -0400, Miller, Terion wrote:
>>
>>
>> On 7/28/09 8:35 AM, "Ashley Sheridan" wrote:
>>
>> $pastDays = strtotime("-30 days");
>> $date = date("d/m/y", $pastDay
On Tue, 2009-07-28 at 06:46 -0700, Miller, Terion wrote:
>
>
> On 7/28/09 8:44 AM, "Ashley Sheridan" wrote:
>
> On Tue, 2009-07-28 at 09:42 -0400, Miller, Terion wrote:
> >
> >
> > On 7/28/09 8:35 AM, "Ashley Sheridan" wrote:
> >
> > $pastDays = strtotime("-30 days");
> > $date = date("d/m/y"
On 7/28/09 8:44 AM, "Ashley Sheridan" wrote:
On Tue, 2009-07-28 at 09:42 -0400, Miller, Terion wrote:
>
>
> On 7/28/09 8:35 AM, "Ashley Sheridan" wrote:
>
> $pastDays = strtotime("-30 days");
> $date = date("d/m/y", $pastDays);
>
> Well I tried and got no results from my query and I know ther
On Tue, 2009-07-28 at 09:41 -0400, Bob McConnell wrote:
> From: Ashley Sheridan
> > On Tue, 2009-07-28 at 09:32 -0400, Miller, Terion wrote:
> >> I need to take this:
> >>
> >>$pastDays = strtotime("-30 days");
> >>
> >>
> >>
> >> $past_day = date("d", $pastDays);
> >>
> >> $past_month = d
On 7/28/09 8:41 AM, "Bob McConnell" wrote:
From: Ashley Sheridan
> On Tue, 2009-07-28 at 09:32 -0400, Miller, Terion wrote:
>> I need to take this:
>>
>>$pastDays = strtotime("-30 days");
>>
>>
>>
>> $past_day = date("d", $pastDays);
>>
>> $past_month = date("m", $pastDays);
>>
>> $past_ye
On Tue, 2009-07-28 at 09:42 -0400, Miller, Terion wrote:
>
>
> On 7/28/09 8:35 AM, "Ashley Sheridan" 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 d
From: Ashley Sheridan
> On Tue, 2009-07-28 at 09:32 -0400, Miller, Terion wrote:
>> I need to take this:
>>
>>$pastDays = strtotime("-30 days");
>>
>>
>>
>> $past_day = date("d", $pastDays);
>>
>> $past_month = date("m", $pastDays);
>>
>> $past_year =date("y", $pastDays);
>>
>>
>> And m
On 7/28/09 8:35 AM, "Ashley Sheridan" 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 strt
On Tue, Jul 28, 2009 at 6:32 AM, Miller,
Terion wrote:
> I need to take this:
>
> Â $pastDays = strtotime("-30 days");
>
>
>
> $past_day = date("d", $pastDays);
>
> $past_month = date("m", $pastDays);
>
> $past_year =date("y", $pastDays);
>
>
> And make it into one var to compare to a db field tha
On Tue, 2009-07-28 at 09:32 -0400, Miller, Terion wrote:
> I need to take this:
>
>$pastDays = strtotime("-30 days");
>
>
>
> $past_day = date("d", $pastDays);
>
> $past_month = date("m", $pastDays);
>
> $past_year =date("y", $pastDays);
>
>
> And make it into one var to compare to a db
I need to take this:
$pastDays = strtotime("-30 days");
$past_day = date("d", $pastDays);
$past_month = date("m", $pastDays);
$past_year =date("y", $pastDays);
And make it into one var to compare to a db field that is formatted like
00/00/00
--
PHP General Mailing List (http://www.php
21 matches
Mail list logo