Hi Jay, tnx for answering!
You were right, the $count variable wasn't right, that was still from a example I used.
The new code is:
- if ($_POST['update'] == "update") {
global $dbh;
// $count = 1;
foreach ($array as $idval) {
$query = $dbh->query("UPDATE deelnemers SET poule = 51 WHERE user_id = 15") or die('Error, insert query failed');
// $count ++;
}
}
The real challenge for me is to how to get the right user_id and poule number in the query.
I want to know 2 things:
1. How to get the ID of the user block I'm dragging to poule 1 or poule 2?
2. How to get the poule number in which the user block is dropped to?
Kind regards,
Arie