Please Help!!! one to many relationships?

[eluser]BlackstoneDigital[/eluser]
Hello,

What you would do is do a select statement to get your employees. Try this:

Code:

$taskID = 1; //whatever your query string returned.
$query = $this->db->query("SELECT employeeID FROM Staff_table WHERE tasks < 5"); // or whatever

foreach ($query->result() as $row)
{
   $this->db->query( "INSERT INTO assigned_tasks (employeeID, taskID) VALUES (" . $row->employeeID . ", " . $taskID . ")" );
}

Have a go with that.