Why would this query behave this way??
| From: | Owen Parker | Date: | Wed, 02 Oct 2002 15:40:13 +0000 |
| Subject: | Why would this query behave this way?? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22162@lists.php.net to get a copy of this message | ||
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