hi all this query:
SELECT updates.MODELCODE, SETNO, FRPICNO, TOPICNO, CPOSTDATE, MODELNAME, ZIPFILENAME, TOTPICS FROM updates, models WHERE updates.MODELCODE = models.MODELCODE AND CPOSTDATE <= CURDATE() AND CPOSTDATE >= ( CURDATE() - 14 ) ORDER BY CPOSTDATE LIMIT 0, 30 worked perfectly until the result was an empty array and then it decided to list all database rows. How come? many tia for any answers or pointers... l8r owen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php