niquel

Actually no I am not talking about any calendar program as none seem to do what I am looking to do. Exactly what I am looking at doing is entering several state and county fairs in a database but i will want members of my site to be able to select dates they played and be able to show previous years what fairs or festivals they were at last year and 2 years ago. The main thing i am encountering with the site i'm working on when i am entering dummy fairs and festivals for testing purposes when i change the dates of the fair it always deletes the old date.

Hi all first off I am new here so let me take a second and say hello to everyone for the first time.Iam also fairly new at working with php and mysql actually trying to create my first site using these however I am kind of stuck at how to do something so that it comes out right hopefully you can help me out here.i am trying to figure out how to do multiple entries for the same field an example is this an event calendar where the event is held yearly and I want to be able to go back each year and pull up the info that was entered for previous yearsi.e. an event is held July 4 - July 10, 2009 however the way i have mysql configured when email is sent on July 11th congratulating them on a hopefully sucessful year and remind them to update for the next years event once the user updates the dates with the 2010 dates July 7- July 13, 2010 I can no longer view when the 2009 event was held I am sure there is a way to fix this but I am not sure how please help.