Re: mysql/php select using date in where clause

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 >