setting expiry date

2005-09-12 Thread ross
I have a php/mysql database with articles. What I need is a php sctipt or some mysql that will compare the current day with the 'expiry date' entered by the user and if the there is a difference then drop it from the database.. I am fairly new to mysql so do not know if there is a way to

Re: setting expiry date

2005-09-12 Thread tony
not sure i completely understand your question but i think the user enters a date, and you want to delete all records that match that date? also i'm assuming that the entered date hits your script as a post variable. if so, you need to convert the posted date into the same format as the records