IT works!
Thanks!
martin helie [EMAIL PROTECTED] skrev i en meddelelse
9crqud$voj$[EMAIL PROTECTED]">news:9crqud$voj$[EMAIL PROTECTED]...
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 [EMAIL PROTECTED] wrote in message
9crq7l$mfb$[EMAIL PROTECTED]">news:9crq7l$mfb$[EMAIL PROTECTED]...
***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 [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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]