I would use JOIN syntax - then change your join type based on what you want to see in the results...(INNER JOIN, LEFT JOIN, RIGHT JOIN, LEFT OUTER etc.)
SELECT updates.MODELCODE, SETNO, FRPICNO, TOPICNO, CPOSTDATE, MODELNAME, ZIPFILENAME, TOTPICS FROM updates LEFT JOIN models ON updates.MODELCODE = models.MODELCODE WHERE CPOSTDATE <= CURDATE() AND CPOSTDATE >= ( CURDATE() - 14 ) ORDER BY CPOSTDATE LIMIT 0, 30 (should preface ALL your columns with the table name just to be safe - makes it more readable too) -----Original Message----- From: Owen Parker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 11:43 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Why does this happen?? 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
