Re: mysql_query problem...
| From: | Marek Kilimajer | Date: | Tue, 29 Apr 2003 11:20:52 +0000 |
| Subject: | Re: mysql_query problem... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-145622@lists.php.net to get a copy of this message | ||
This should go to the mysql list.
But +/- are available only in mysql > 3.23, try to use
Posted < date_sub(curdate(),interval 15 day)
Prince wrote:
hi have a script that deletes some records based on the fact that the current date and goes 14 days back and deletes anything 14 days or older than todays date... mysql_queryJ("delete from prayer where Posted <curdate()-interval 15 day"); problem i have is it works on windows mysql server but for some reason it wont work on any other one.. any idea how come? all i get for the query is -1