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
