mysql/php select using date in where clause
| From: | Dan Eskildsen | Date: | Thu, 03 May 2001 14:36:50 +0000 |
| Subject: | mysql/php select using date in where clause | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9095@lists.php.net to get a copy of this message | ||
***NEWBIE ALERT*** (I am only very new at this)
PHP and MySQL
OK - I have a table with data and one of the fields is a Date field.
Now I would like to SELECT all records where the date is less that 45 days
old.
Eh, How do I do that?
I have tried this:
#Declaring variables
$today=date("Y-m-d");
$lastmonth = $today-30
$query = "SELECT * FROM customers WHERE Site='egebjergnet' AND
DatoOprettet>'$lastmonth' ORDER BY FirmaNavn";
AND I get an error, of course. hmmm
--
==================================
Regards from Denmark, Europe
Please cc your reply to dan@eskildsen.net
==================================
I haven't lost my mind, I've got it backed up on TAPE somewhere.......