orion2004 Posted September 12, 2006 Share Posted September 12, 2006 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: psych0krazyMSN: isenhart2004@hotmail.com Thanks in advance Quote Link to comment Share on other sites More sharing options...
fenway Posted September 12, 2006 Share Posted September 12, 2006 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. Quote Link to comment Share on other sites More sharing options...
orion2004 Posted September 13, 2006 Author Share Posted September 13, 2006 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted September 13, 2006 Share Posted September 13, 2006 Post the table structure, and I'll see what I can do. Quote Link to comment Share on other sites More sharing options...
orion2004 Posted September 13, 2006 Author Share Posted September 13, 2006 could you by chance contact me via MSN or AIM? Quote Link to comment Share on other sites More sharing options...
orion2004 Posted September 13, 2006 Author Share Posted September 13, 2006 Table = Raid_CalendarRow = Day , Instance , TimeI 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted September 13, 2006 Share Posted September 13, 2006 The following psuedo-code should be useful:UPDATE raid_calendar SET instance = '<PHP variable>', time = '<PHP variable>' WHERE day = '<PHP variable>' Quote Link to comment Share on other sites More sharing options...
orion2004 Posted September 13, 2006 Author Share Posted September 13, 2006 Thanks now it works Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.