PROTECTED]
Sent: Monday, March 03, 2003 2:24 PM
To: [EMAIL PROTECTED]
Subject: Re: Selecting from mySql database regarding dates
What happens if you statically set the dates in your query such as this:
SELECT * FROM designs, appliquetable, puffyfoamtable WHERE
designs.designadddate <
Here's how I would do it. (I'm sure that you'll probably get other
solutions as well.)
$query = "SELECT * FROM designs, appliquetable, puffyfoamtable WHERE
designs.puffyfoam = puffyfoamtable.puffyfoam AND
designs.applique = appliquetable.applique AND
TO_DAYS(NOW
because I echo'd the results of $today and $twoweeksago and I know
they're calculating correctly???
Any ideas on where to go from here?
-Original Message-
From: Ray [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 1:36 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re:
try 's arround the dates
$query = "SELECT * FROM designs, appliquetable, puffyfoamtable WHERE
designs.puffyfoam = puffyfoamtable.puffyfoam AND
designs.applique = appliquetable.applique AND
>(designs.designadddate <= '$today' AND
> designs.designa
I have a column in my mySql database that holds a date that I've added each
record called
designadddate
I'm trying to create a filter to only pull up the records that have been
added over the last two weeks. This is my code ... I added the echo for the
$today and $twoweeksago variables to make su
