"SELECT CURDATE() - 14" ... this isn't doing what you think it's doing.
The CURDATE() function returns a string like "2002-10-03".
Subtracting 14 from that gets you "20020989" as a result from MySQL.
Pretty useless, right? If that ever worked for you, it was a total
coincidence.
Try this instead:
SELECT DATE_SUB( CURDATE(), INTERVAL 14 DAY )
That will get you the date from 14 days ago.
See the MySQL manual for descriptions of the functions.
I'm sure that the MySQL site has references to MySQL mailing lists too, to
help with MySQL questions.
g.luck,
~Chris
On Thu, 3 Oct 2002, Owen Parker wrote:
> hi all
>
> have a really simple query:
>
> $twowksworth = @mysql_query("SELECT updates.MODELCODE, updates.SETNO,
> updates.FRPICNO, updates.TOPICNO, updates.CPOSTDATE, updates.ZIPFILENAME,
> updates.TOTPICS, models.MODELNAME FROM updates LEFT JOIN models ON
> updates.MODELCODE = models.MODELCODE WHERE updates.CPOSTDATE >= (
> CURDATE() - 14 )AND updates.CPOSTDATE <= CURDATE() ORDER BY
> updates.CPOSTDATE " ) ;
>
> When this was originally written it worked like a charm. I purposefully
> let it 'run out' of data by not adding any more to the table. each day for
> two weeks the list resulting from this query got shorter as expected. The
> day after there was no data, it started listing the entire contents of the
> table. What the...
>
> So i added a few weeks worth of data and now it correctly cuts off at
> today's dat but it completely ignores the curdate() - 14 portion and lists
> the entire table up to today's date.
>
> this is so basic i cant figure it out. besides, it used to work. what
> gives? I'm really new to php and mysql, but until now felt i had made good
> progress in the past couple
> weeks. just cant figure out how to troubleshoot this error due to lack of
> experience and knowledge.
>
> is there something really basic i am missing here? any pointers would be
> greatly appreciated!!
>
> tia
>
> owen
>
>
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
