Jump to content



Welcome to AstaHost - Dear Guest , Please Register here to get Your own website. - Ask a Question / Express Opinion / Reply w/o Sign-Up!

Toggle shoutbox Shoutbox Open the Shoutbox in a popup

@  yordan : (14 April 2014 - 05:28 PM) By The Way, This Could Be An Interesting Subject For A Topic, What About Posting This Question? Let's See If Other People Have The Same Feeling Concerning Bootlists!
@  yordan : (13 April 2014 - 09:36 AM) Boot Order : Cd, [Usb,] Hard Drive :D
@  yordan : (11 April 2014 - 07:23 PM) I Simply Let The Bios Do That
@  Ritesh : (11 April 2014 - 10:23 AM) Is It Possible To Launch Fedora Live Cd Or Installation Disk From Hard Drive On Windows Platform Using Grub Mbr File.
@  Ritesh : (11 April 2014 - 10:21 AM) No U Are Not.. Btw.. I Have Question For You.
@  yordan : (10 April 2014 - 08:02 AM) You Are Partially Right.
I Was Not.
Nevertheless, I Am Again :)
@  Ritesh : (09 April 2014 - 07:33 PM) :P
@  Ritesh : (09 April 2014 - 07:33 PM) I Think U R Not..
@  yordan : (09 April 2014 - 09:28 AM) I'm The Master Of The Shoutbox!
@  yordan : (05 April 2014 - 10:32 PM) He-He
@  Ritesh : (04 April 2014 - 06:59 PM) Ha Ha Ha ....
@  yordan : (04 April 2014 - 11:15 AM) Welcome Back, Starscream!
@  yordan : (03 April 2014 - 02:31 PM) And I Hope That He Will Come Back Soon :)
@  yordan : (01 April 2014 - 02:53 PM) Nice, Ritesh Came, I'm Not Home Alone Today.
@  Ritesh : (01 April 2014 - 08:51 AM) Oh!!! Poor Dear Yordan..
@  yordan : (31 March 2014 - 10:02 AM) I'm A Poor Lonesome Cow-Boy
@  yordan : (27 March 2014 - 02:22 PM) He Is Unpatient Due To His Patients!
@  Ritesh : (27 March 2014 - 10:46 AM) :(
@  Ritesh : (27 March 2014 - 10:46 AM) He Is Busy With His Patients.
@  yordan : (26 March 2014 - 08:12 PM) Ahsani, Where Are You?

Photo
- - - - -

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


4 replies to this topic

#1 niquel

niquel

    Newbie [ Level 1 ]

  • Members
  • 2 posts

Posted 17 June 2009 - 09:50 PM

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.

#2 yordan

yordan

    Way Out Of Control - You need a life :)

  • [MODERATOR]
  • 4,745 posts

Posted 18 June 2009 - 08:55 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 ?

#3 niquel

niquel

    Newbie [ Level 1 ]

  • Members
  • 2 posts

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.

#4 fiage

fiage

    Advanced Member

  • Members
  • 154 posts

Posted 19 June 2009 - 06:40 AM

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.

#5 TavoxPeru

TavoxPeru

    Super Member

  • [HOSTED]
  • 876 posts
  • Gender:Male
  • Location:Lima - Peru
  • Interests:Web and Software development, Internet, Computers, Electronic music, music, soccer.
  • myCENTs:13.21

Posted 20 June 2009 - 10:51 AM

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,



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users