Re: php/mySql SELECT where clause using dates.

Take out the order by clause or chaqnge it. You can't order by a column you aren't selecting. ----- Original Message ----- From: "Dan Eskildsen" <dan@eskildsen.net> To: <php-general@lists.php.net> Sent: Thursday, May 03, 2001 10:30 AM Subject: [PHP] php/mySql SELECT where clause using dates. > ***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 General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >