Why does this happen??
| From: | Owen Parker | Date: | Wed, 02 Oct 2002 15:42:47 +0000 |
| Subject: | Why does this happen?? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22161@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