Jump to content

Archived

This topic is now archived and is closed to further replies.

orion2004

Looking for some minor help.

Recommended Posts

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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
Post the table structure, and I'll see what I can do.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
The following psuedo-code should be useful:

UPDATE raid_calendar SET instance = '<PHP variable>', time = '<PHP variable>' WHERE day = '<PHP variable>'

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.