That brought me up the record that was dated 3/1 but not the ones dated 2/17 and 2/18 which fit into the criteria also ....
We're getting there .... is there something going on with the fact that the other two are in the previous month? That's kinda freaky considering that I know 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: Selecting from mySql database regarding dates 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.designadddate >= '$twoweeksago')GROUP BY catcode ORDER BY designfile"; otherwise your getting 2003 minus 3 minus 3 (2003-3-3) On Monday 03 March 2003 12:01, you wrote: > 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 sure something was being > calculated, they are showing up correct as 2003-03-03 and 2003-02-17 ... > but it isn't pulling up any records -- it's not bombing out and giving me > the Couldn't execute query message - but I know there's three records that > I made sure had dates in between this range. I also tried using BETWEEN > and it didn't seem to work either. > > > > $today = date ("Y-m-d"); > $twoweeksago = date("Y-m-d",mktime(0,0,0,date(m), date(d)-14, date(Y))); > > echo"$today\n"; > echo"$twoweeksago\n"; > > /* Select designs of the given type */ > $query = "SELECT * FROM designs, appliquetable, puffyfoamtable WHERE > designs.puffyfoam = puffyfoamtable.puffyfoam AND > designs.applique = appliquetable.applique AND > (designs.designadddate <= $today AND > designs.designadddate >= $twoweeksago)GROUP BY > catcode ORDER BY designfile"; > $result = mysql_query($query) > or die ("Couldn't execute query."); > > > > Any help would me much appreciated! > > TIA > Renee Toth > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- mysql, sql, query, sql, sql, sql --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
