Delet Query

WeberForums.com Forum Index -> MySQL General

View previous topic :: View next topic   Author Message trawets Joined: 26 Mar 2008 Posts: 1 Location: UK Posted: Wed Mar 26, 2008 11:28 pm    Post subject: Delet Query Hi I am trying to run the MySQL delete query in phpMyAdmin, now the query runs and doesn't give any syntax errors, but it also doesn't delete and rows From the query you can see the table name (jos_content) and two fields, state (-1 = unpublished) and publish_down, Code: DELETE FROM jos_content WHERE state=-1 AND DATE_ADD(publish_down, INTERVAL '90' DAY) = CURRENT_DATE so what I am trying to achieve is that any entries that are not published and and its been 90 days since they were unpublished I would like to delete them, but as I say it runs but does not delete any entries so I'm guessing that there is something wrong with interval part any suggestions please Back to top lostboy Joined: 02 May 2004 Posts: 4958 Location: toronto, canada Posted: Thu Mar 27, 2008 3:21 am    Post subject: DELETE FROM jos_content WHERE state=-1 AND publish_down = date_sub(CURRENT_DATE INTERVAL '90' DAY) _________________ Lostboy Cat, the other other white meat Please read Posting Etiquette before posting You can always try Google Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First

WeberTrivia Questions   Think you are smart? Prove it!. Try your skills with these questions :   Recursive arrays and multi-dimensional arrays are one and the same. (PHP and MySQL)   The \"cache_dir\" tag of the squid configuration has a default of /var/spool/squid. (Linux)

	WeberForums.com Forum Index -> MySQL General	All times are GMT + 2 Hours
Page 1 of 1

Jump to: Select a forum PHP Forums----------------PHP GeneralPHP MySQL Jobs and ProjectsPHP Articles Tutorials and ScriptsWhy Use PHPPEARPHP Books MySQL Forums----------------MySQL General Apache Forums----------------Apache General Web Development Forums----------------Java Script / AJAXSearch Engine Optimization (SEO)Cascading Style SheetsHTMLXML & XSL Graphics & Design----------------Theory related web designWeb Design Security Forums----------------Security Linux Forums----------------Linux General Web Development Misc----------------Hosting Related Miscellaneous----------------Feedback & TestimonialsMisc  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum