 |
 |
Find a programming school near you
php-db | 2001051
Date: 05/03/01
- Next message: Miles Thompson: "Re: [PHP-DB] postgres tutorials?"
- Previous message: Jaxon: "[PHP-DB] postgres tutorials?"
- Next in thread: martin helie: "Re: [PHP-DB] mysql/php select using date in where clause"
- Reply: martin helie: "Re: [PHP-DB] mysql/php select using date in where clause"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
***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 <email protected> ================================== I haven't lost my mind, I've got it backed up on TAPE somewhere.......-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe <email protected> For additional commands, e-mail: php-db-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>
- Next message: Miles Thompson: "Re: [PHP-DB] postgres tutorials?"
- Previous message: Jaxon: "[PHP-DB] postgres tutorials?"
- Next in thread: martin helie: "Re: [PHP-DB] mysql/php select using date in where clause"
- Reply: martin helie: "Re: [PHP-DB] mysql/php select using date in where clause"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
