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
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:
2 matches
Mail list logo