RE: [PHP] Date Arithmetic

2002-10-01 Thread John W. Holmes
> I have a small but hard to solve problem to solve. > Wrote a Select Query for my webpage. > The query should select all values which where > written into the DB the last seven Days. > I thought everything was working fine, but now > the month has changed and everything went > wrong. > My Select

Re: [PHP] Date Arithmetic

2002-10-01 Thread Kevin Stone
Look into DAYOFYEAR on www.mysql.com. I think you can develope a SELECT statement to do what you need. Might get more help on the PHP-DB list. Good luck. -Kevin - Original Message - From: "Sascha Braun" <[EMAIL PROTECTED]> To: "PHP General" <[EMAIL PROTECTED]> Sent: Tuesday, October 01,

Re: [PHP] Date Arithmetic

2002-10-01 Thread Robert Cummings
Sascha Braun wrote: > > I have a small but hard to solve problem to solve. > > Wrote a Select Query for my webpage. > > The query should select all values which where > written into the DB the last seven Days. > > I thought everything was working fine, but now > the month has changed and every