Hello Everyone,
I have to start by saying that I am very new to phprunner, and even mysql, but I have found 5.1 and 5.2 to be an amazing tool. I actually talked my company in to purchasing it. So the problem I am having is that I am almost finished with setting up a logging db with phprunner, but I am running in to an issue of updating another table with information from another table. Example:::
Table Event_Log
Event_Type Event_Sub_Type Event_Category Event_Date_Time Assigned_Group Event_Description General_Notes Status
Table Event_Activity
Event_Activity_Group Reassign_Group Escalation Status Assigned_Group General_Notes Date_Time
The Event_Log table is the one the user see's when they click add new they are asked questions relating to the fields listed above. After the record is added it will automatically create a new record in the Event_Activity table which will now show as a child to the Event_Log.
What I would like to do is when the user clicks on the child and the Event_Activity table is displayed they can click new to update that record, but when they finish with the new record I want the fields that are related to that record in the Event_Log updated, instead of it creating a new record in the Event_Log table. Please let me know if you need more information.
SELECT
EventType,
EventSubType,
EventCategory,
EventDate_Time,
EventGroup,
EventDescription,
EventActivity,
EventResolution,
EventEscalation,
EventID
FROM event_log
SELECT
EventActivityID,
EventID,
EventActivityType,
EventActivityGroup,
EventActivityDescription,
EventActivityDate_Time,
EventActivityReassign,
EventActivityEscalation,
EventActivityResolution
FROM eventactivity