Re: Making several variables into 1 variable
| From: | Miller, Terion | Date: | Tue, 28 Jul 2009 13:42:29 +0000 |
| Subject: | Re: Making several variables into 1 variable | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-295920@lists.php.net to get a copy of this message | ||
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' ";