I have 3 tables.
Tables
When I insert data to the ekf_parag I do it like this:
$ekfonites = $_POST['ekfonites'];
foreach ($ekfonites as $ekfonitis) {
$parago = $db_con->prepare('SELECT MAX(id) FROM paragoges');
$parago->execute();
$paragoges_id = $parago->fetchColumn();
$ekf = $db_con->prepare('INSERT INTO ekf_parag(id, paragoges_id, ekf_id, ekfonisan) VALUES("", :paragoges_id, :ekfonitis, 0)');
$ekf->bindParam(':ekfonitis', $ekfonitis);
$ekf->bindParam(':paragoges_id', $paragoges_id);
$ekf->execute();
}
But when I try to update the table I don't know how to trigger the id from table paragoges. Because it's important (I think) to put the update query inside the foreach, cause there is not only one value in the $ekfonites variable.
Please help me!