Re: mysql/php select using date in where clause

IT works! Thanks! ""martin helie"" <martinh@ureach.com> skrev i en meddelelse news:9crqud$voj$1@toye.p.sourceforge.net... > Here's how I'd do it: > > SELECT * FROM customers WHERE Site='egebjergnet' AND > > TO_DAYS(NOW()) - TO_DAYS(date_column) <= '45' > > where date_column contains record dates... > > Martin > > > > ""Dan Eskildsen"" <dan@eskildsen.net> wrote in message > news:9crq7l$mfb$1@toye.p.sourceforge.net... > > ***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....... > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >