[eluser]Unknown[/eluser]
Hi everyone,
I am pretty new to code igniter but have some experience with PHP. This is my first production app using CI and I have stumbled at the 1st hurdle.
I am trying to make a system to distribute tasks to employee's. When a new task is loaded in the system I want the user to be able to click a button/link then send the same task to 5 employee's.
The DB will have 3 tables Tasks_table, Staff_table, and Assigned_Tasks_table.
The Assigned_Tasks table will store the key's from the other 2 tables (kinda like a shopping cart).
I have extracted the task_id from the URI and can write that to the Assigned-tasks table, I have also run a query to extract 5 employees with the least number of current tasks.
How do I take the output from this query and insert the staff_id fields of the 5 results into 5 records of the assigned_tasks table?
I hope someone can help, I am really stuck!!
Any questions please ask!