PHP - Php Pdo Updating The Database With A Loop?/foreach?

Hey guys..i have an issue i can't seem to fix...

i have a table with codes and userid to associate  the code to a user

i need to make it that a user can give codes to another user.

i have a form .  from user to other user with amount of codes

so i have tried many combos..

$UserID =   mysqli_real_escape_string($DBcon, $_POST['OwnerID']);
$NewRId =   mysqli_real_escape_string($DBcon, $_POST['SubID']);
$Cr =       mysqli_real_escape_string($DBcon, $_POST['credits']);

tried with range

$t = array();
$counter = 0;
foreach (range(0, $Cr) as $t) {
	$sql = "UPDATE `Codes` SET `UserID`= '$NewRId' WHERE `UserID` = '$UserID'";
	$counter ++;
	echo $counter;
}
$result = mysqli_query($DBcon,$sql);
	if (!$result) {
	    trigger_error("UPDATE query failed: " . mysqli_error(), E_USER_ERROR);
	}
but it takes all the ocdes from user one to user two...

tried also:
 foreach ($Cr as $t) {
	$sql2 = "UPDATE `Codes` SET `UserID`= '$NewRId' WHERE `UserID` = '$UserID'";
 	if ($DBcon->query($sql2) === TRUE) {
     echo "<meta http-equiv=Refresh content=1;url=SwapC.php?success=1 >";
	} else {
		 echo "Error updating record: <br>" . $DBcon->error;
	}
 }
but does not work...

        // validate input
        $valid = true;
        if (empty($store_name)) {
            $storeNameError = 'Please enter a Store Name';
            $valid = false;
        }

        if (empty($item_description)) {
            $itemDdescriptionError = 'Please enter an Item Description';
            $valid = false;
        }

        if (empty($qty_pkg)) {
            $qtyPkgError = 'Please enter Quantity or Package';
            $valid = false;
        }

        if (empty($pkg_of)) {
            $pkgOfError = 'Please enter the Count/Quantity';
            $valid = false;
        }

    // Create an array of the fields we want to capture, along with their labels
    $fields = array(
        'store_name'=>'Store Name',
        'item_description'=>'Item Description',
        'qty_pkg'=>'Qty / Pkg',
        'pkg_of'=>'Pkg. Of',
        'price'=>'Price',
        'flyer_page'=>'Flyer Page #',
        'limited_time_sale'=>'Limited Time Sale Days',
        'nos_to_purchase'=>'Nos. to Purchase'
    );

    // Create an array-type variable to keep track of validation errors
    $fieldsErrorMsgs = array(
        'storeNameError'=>'Please enter a Store Name',
        'itemDescriptionError'=>'Please enter an Item Description',
        'qtyPkgError'=>'Please enter Qty or Pkg',
        'pkgOfError'=>'Please enter the Qty',
        'priceError'=>'Please enter the Price',
        'flyerPageError'=>'Please enter the Flyer Page #',
        'limitedTimeSaleError'=>'Please enter the Limited Time Sale Days',
        'nosToPurchaseError'=>'Please enter the No(s). to Purchase'
    );

        $valid = true;
        $errors = array();
        
        foreach($fields AS $field=>$label){
            //The following line is using the ternary operator, it's basically a shorthand if/else assignment.  
            $errors[$field] = (!isset($values['store_name']) || !strlen($values['store_name'])) ? $errors[$label] = 'Mandatory field, input required!' : NULL;

            if(!strlen($errors[$label])){
                $valid = false;            
            }
        }  
 
        // insert data
        if ($valid) {
            $pdo = Database::connect();
            $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            $sql = "INSERT INTO shoplist (store_name,item_description,qty_pkg,pkg_of,price,flyer_page,limited_time_sale,nos_to_purchase,shopper1_buy_flag,shopper2_buy_flag,purchased_flag,purchase_later_flag)
                    VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
            $q = $pdo->prepare($sql);
            $q->execute(array($store_name,$item_description,$qty_pkg,$pkg_of,$price,$flyer_page,$limited_time_sale,$nos_to_purchase,$initialize_flag,$initialize_flag,$initialize_flag,$initialize_flag));
            Database::disconnect();
            header("Location: index.php");
        }

            <form class="form-horizontal" action="create.php" method="post">            
                <?php
                    foreach($fields AS $field=>$label){
                        //Print the form element for the field.
                        echo "<label>{$label}:<br>";
                        //If the field had an error, display it.
                        if(isset($errors[$field])){
                            echo ' <span class="error">'.$errors[$field].'</span><br>';
                        }
                        //Echo the actual input. If the form is being displayed with errors, we'll have a value to fill in from the user's previous submission.
                        echo '<input type="text" name="'.$field.'"';
                        if(isset($values[$field])){
                            echo ' value="'.$values[$field].'"';
                        }
                        echo '/></label>';
                    }
                ?>
                <div class="form-actions">
                    <button type="submit" class="btn btn-success">Create</button>
                    <a class="btn" href="index.php">Back</a>
                </div>
            </form> 

function displayMenuCategories($menu_category){
        $display_menu ="";
        $category_id =  $menu_category['menu_cat_id'];
        $display_menu .=   "<div class='menu_cat'>{$menu_category['menu_cat_name']}</div><br>\n";
        if(!empty($menu_category['menu_cat_desc'])) {
        $display_menu .= "<div class='menu_desc'>{$menu_category['menu_cat_desc']}</div>\n";
        }


    $category_info = array("display" => $display_menu, "category_id" => $category_id );

    return $category_info;
}

$left_menu_categories // Is the array that contains all the menu categories 

foreach($left_menu_categories as $left_menu_category){

    $get_categories =  displayMenuCategories($left_menu_category);

}
var_dump($get_categories);