Welcome to AstaHost - Dear Guest , Please Register here to get Your own website. - Ask a Question / Express Opinion / Reply w/o Sign-Up!
Mysql --- Multiple Entries Single Field how can i do this?
Posted 17 June 2009 - 09:50 PM
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 years
i.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.
Posted 19 June 2009 - 02:13 AM
You seem to be talking about an existing and already (almost correctly) working calendar environment. Which calendar system over mysql are you talking about ?
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.
Posted 19 June 2009 - 06:40 AM
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users