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]
