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]
