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: [email protected] Thanks in advance Link to comment https://forums.phpfreaks.com/topic/20547-looking-for-some-minor-help/ 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. Link to comment https://forums.phpfreaks.com/topic/20547-looking-for-some-minor-help/#findComment-90687 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 Link to comment https://forums.phpfreaks.com/topic/20547-looking-for-some-minor-help/#findComment-91167 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. Link to comment https://forums.phpfreaks.com/topic/20547-looking-for-some-minor-help/#findComment-91178 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? Link to comment https://forums.phpfreaks.com/topic/20547-looking-for-some-minor-help/#findComment-91192 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 Link to comment https://forums.phpfreaks.com/topic/20547-looking-for-some-minor-help/#findComment-91194 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>' Link to comment https://forums.phpfreaks.com/topic/20547-looking-for-some-minor-help/#findComment-91286 Share on other sites More sharing options...
orion2004 Posted September 13, 2006 Author Share Posted September 13, 2006 Thanks now it works Link to comment https://forums.phpfreaks.com/topic/20547-looking-for-some-minor-help/#findComment-91354 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.