westman Posted October 27, 2011 Share Posted October 27, 2011 hi all, i am trying to get post's in my database deleted after 4 weeks and 12 weeks using mysql_queryi tried in php but no luck this is what i have so fear... mysql_query("INTERVAL 30 DAY SELECT FROM post , DELETE, WHERE id ='0'"); and also mysql_query("DELETE FROM post WHERE id='0' AND date='<=CURRENT_DATE - INTERVAL 30 DAY'"); *please don't look at id as v id i gust changed it for this post would any of the 2 above work? Link to comment Share on other sites More sharing options...
thescientist Posted October 27, 2011 Share Posted October 27, 2011 haven't you already asked this question?http://w3schools.invisionzone.com/index.php?showtopic=40412 Link to comment Share on other sites More sharing options...
westman Posted October 27, 2011 Author Share Posted October 27, 2011 and not yet got a working script to delete data from my database that is 4weeks old Link to comment Share on other sites More sharing options...
thescientist Posted October 27, 2011 Share Posted October 27, 2011 so? why did you need to make a new thread for it? it seemed like you were given plenty of suggestions in your other thread. why not just reply there with your ongoing issues related to the exact same topic. what did you think starting a new thread would do? it will only confuse people, and clog up the forums with redundancy. Link to comment Share on other sites More sharing options...
Synook Posted October 28, 2011 Share Posted October 28, 2011 Duplicate thread: http://w3schools.inv...showtopic=40412. This is not an enterprise-level support forum with guaranteed results or else - people will contribute what they can to help you solve your problem, but you have to work with them. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.