Jump to content


Photo

Looking for some minor help.


  • Please log in to reply
7 replies to this topic

#1 orion2004

orion2004
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 12 September 2006 - 08:19 PM

I am looking for someone who has Mysql and php knowledge. What im wanting to do is have a form for example:

Day        |    FORM FIELD  |
Instance |    FORM FIELD    |
Time      |    FORM FIELD    |


and basicly what i have done is created a mysql database that already has the Days in it Monday and so on.

Now instance and time are drop downs and when they change it i want it to update the correct day in mysql with the information form the fields. Please let me know if you can help me.

AIM: psych0krazy
MSN: isenhart2004@hotmail.com

Thanks in advance

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 12 September 2006 - 09:04 PM

This can be accomplished with a simple update statement, but you have to design a method to pull & push this information, and populate the fields accordingly.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 orion2004

orion2004
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 13 September 2006 - 04:34 PM

Is it possible you could write me a sample update statement for what ill need. Im kinda new and sadly i only learn from editing others codes. thanks

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 13 September 2006 - 04:41 PM

Post the table structure, and I'll see what I can do.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#5 orion2004

orion2004
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 13 September 2006 - 04:57 PM

could you by chance contact me via MSN or AIM?

#6 orion2004

orion2004
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 13 September 2006 - 05:04 PM

Table = Raid_Calendar

Row = Day , Instance , Time


I already manually put in 7 Rows with each day in them so the only thing that really needs updating is the instance and time.

I have a form that has 3 drop downs. 1 is the day 2 is the instance and 3 is the time. What im wanting is when you select Monday and instance ZG and Time 4:00 it will select the row with the Day already in it and change the instance and time within it. Thanks

#7 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 13 September 2006 - 07:27 PM

The following psuedo-code should be useful:

UPDATE raid_calendar SET instance = '<PHP variable>', time = '<PHP variable>' WHERE day = '<PHP variable>'
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#8 orion2004

orion2004
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 13 September 2006 - 08:49 PM

Thanks now it works




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users