Mysql --- Multiple Entries Single Field how can i do this?

	Mysql --- Multiple Entries Single Field - how can i do this?
	Discussion by niquel with 4 Replies. Last Update: June 20, 2009, 10:51 am

niquel

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 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.

Wed Jun 17, 2009 Reply New Discussion

yordan

You seem to be talking about an existing and already (almost correctly) working calendar environment. Which calendar system over mysql are you talking about ?

Thu Jun 18, 2009 Reply New Discussion

niquel

QUOTE (yordan)

You seem to be talking about an existing and already (almost correctly) working calendar environment. Which calendar system over mysql are you talking about ?
Link: view Post: 137732

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.

Fri Jun 19, 2009 Reply New Discussion

Spencer

You can create another MySQL table with fair name, and date fields. And you can use this table to display in the users past visited page. To do this you need to capture the data user selects and put it in this second table too and then write the appropriate php code to show it. This method will keep your database and code of your calendar management unaltered and you also get what you wanted.

Fri Jun 19, 2009 Reply New Discussion

TavoxPeru

If i understood, you are updating the old dates with the new ones using the SQL UPDATE, correct???.

please, could you post your php code that manages this task and also your table(s) structure(s)???

Best regards,

Sat Jun 20, 2009 Reply New Discussion