I am developing an application in which i have table with 3 columns (id, name and date).
Now in date field I am storing date the user joined, but now i want to delete the user records which are over 4 days old, from the original date of joining.
I want something like this...
there is entry on date field 4/6/2013
Now after 4 days i.e. on 8/6/2013 all the records having 4/6/2013 date will be removed autometically... This should be done automatically.. Lets say when the server time gets 12:00AM it should be happen automatically... How can i achieve this?
Please help me out..?
Thanks in advance.