Thread: dates expiring

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Olympia
    Posts
    19
    Rep Power
    0
    Whats the code to delete something if a date has expired. For example if there was a concert on 6/29/00 whats the code to delete it out of the database on 6/30/00
  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15

    <<
    Whats the code to delete something if a date has expired. For example if there was a concert on 6/29/00 whats the code to delete it out of the database on 6/30/00
    >>


    issue a sql stament like this...

    "DELETE FROM tablename WHERE date_field>6/30/00";


    make sure that your date format in the datafield is similar to the above dataformat.



    ------------------
    SR -
    webshiju.com
    www.jobxyz.com-IT Career Portal
    ezipindia.com--WebStudio


    "The fear of the LORD is the beginning of knowledge..."

Similar Threads

  1. Date Formatting to search dates correctly
    By cadams in forum MySQL Help
    Replies: 8
    Last Post: January 12th, 2004, 10:09 PM
  2. filling in dates
    By gennyblake in forum MySQL Help
    Replies: 2
    Last Post: July 14th, 2003, 04:19 AM
  3. php to find missing dates in database of articles
    By gennyblake in forum PHP Development
    Replies: 2
    Last Post: July 8th, 2003, 11:42 PM
  4. dates in mysql
    By Ides in forum MySQL Help
    Replies: 1
    Last Post: February 20th, 2003, 09:57 PM
  5. All dates in between 2 dates?
    By Mirax in forum PHP Development
    Replies: 2
    Last Post: January 5th, 2003, 06:29 PM

IMN logo majestic logo threadwatch logo seochat tools logo