i'm sorry, I looked at the wrong part. You need to use the PHP functions to
convert your date to a timestamp, then subtract 30 days from it, then
reconvert to a MySQL date format.
Jon
----- Original Message -----
From: "Jon Rosenberg" <[EMAIL PROTECTED]>
To: "Dan Eskildsen" <[EMAIL PROTECTED]>
Cc: "PHP General List" <[EMAIL PROTECTED]>
Sent: Thursday, May 03, 2001 10:28 AM
Subject: Re: [PHP] 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" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> 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 [EMAIL PROTECTED]
> > ==================================
> > 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
> --
> PHP General 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 General 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]
