$stmt->bind_result($intUserID_DB, $Email_DB, $Phone_DB, $strName, $strWalletAddress);
     //bind results
     $stmt->fetch();
     //fetch the value
     //mysqli_stmt_store_result($stmt);
     //$intTotalRowsFound = mysqli_stmt_num_rows($stmt);
     //echo "totalrows: $intTotalRowsFound <br>";
     $stmt->close();
     //Close statement
 } else {
     echo "Prepare failed: (" . $DB_MYSQLI->errno . ") " . $DB_MYSQLI->error;
 }
 $strWalletAddress = trim($strWalletAddress);
 $strWalletLabel = $intUserID_DB . "|" . $Email_DB . "|" . $Phone_DB . "|" . $strName;
 //echo "making wallet address for ... ".$strWalletLabel."<br>";
 $strWalletAddress = funct_Billing_NewWalletAddress($strWalletLabel);
 if ($strWalletAddress) {
     //update database with new wallet hash code
     //$query="UPDATE " . TBL_USERS . " SET wallet_btc='".$strWalletAddress."' WHERE id=".$intUserID_DB ;
     //echo "SQL STMNT = " . $query .  "<br>";
     //mysqli_query($DB_LINK, $query) or die(mysqli_error());
     if ($DB_MYSQLI->connect_errno) {
         echo "Failed to connect to MySQL: (" . $DB_MYSQLI->connect_errno . ") " . $DB_MYSQLI->connect_error;
     }
     if (!($stmt = $DB_MYSQLI->prepare("UPDATE " . TBL_USERS . " SET wallet_btc = ? WHERE id = ? "))) {
         echo "Prepare failed: (" . $DB_MYSQLI->errno . ") " . $DB_MYSQLI->error;
     }
     if (!$stmt->bind_param('si', $strWalletAddress, $intUserID_DB)) {
         echo "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error;
     }
     if (!$stmt->execute()) {
function funct_MakeWalletAddressUpdate($intUserID, $strCrypto_Code)
{
    //create a new wallet address
    global $DB_LINK;
    //Allows Function to Access variable defined in constants.php ( database link )
    //get info from database for member with hash get their id
    $query = "SELECT * FROM " . TBL_USERS . " WHERE id= '" . $intUserID . "' ";
    //echo "SQL STMNT = " . $query .  "<br>";
    $rs = mysqli_query($DB_LINK, $query);
    // or die(mysqli_error());
    if (mysqli_num_rows($rs) > 0) {
        $row = mysqli_fetch_array($rs);
        $strNameFirst = $row["first_name"];
        //important
        $strNameLast = $row["last_name"];
        //important
        $strEmail = $row["email"];
        //important
        $strPhone = $row["cellphone"];
        //important
        $intCountryID = $row["country_id"];
        $intCountryPhoneCode = $row["country_phonecode"];
        //$strWalletAddress_BTC=		$row["wallet_btc"]; 		//their own personal wallet to forward btc to
        $intBalance = $row["balance"];
        //important
        $intBalanceBTC_old = $row["balance_btc"];
        $intEarnedTotal = $row["total_earned"];
        $strName = $strNameFirst . " " . $strNameLast;
    }
    /* make wallet receiving address or full wallet */
    //get their custom wallet address - Blockchain.info  or local bitcoin qt json rpc
    $strWalletLabel = AlphaNumericOnly_RepaceWithSpace($strEmail);
    //create the new wallet address via json rpc
    //https://github.com/goethewins/EzBit-BitCoin-API--Wallet
    $strWallet_Address = funct_Billing_NewWalletAddress($strEmail);
    if ($strWallet_Address) {
        //update database with new wallet hash code
        $query = "UPDATE " . TBL_USERS . " SET " . $strSQLUpdate . " wallet_receive_on = 1 ,  " . " wallet_address= '{$strWallet_Address}' " . " WHERE id=" . $intUserID;
        //echo "SQL STMNT = " . $query .  "<br>";
        mysqli_query($DB_LINK, $query);
        // or die(mysqli_error());
        //add record to wallet addresses table TBL_WALLET_ADDRESSES
        $query = "INSERT INTO " . TBL_WALLET_ADDRESSES . " ( user_id, \twallet_address,\t \t\tdate_created ) VALUES " . " ( {$intUserID},\t'{$strWallet_Address}',\tNOW() \t  ) ";
        //echo "SQL STMNT = " . $query .  "<br>";
        mysqli_query($DB_LINK, $query);
        //$intWalletID = mysqli_insert_id($DB_LINK);
        //add record to balances table - must only be on record per crypto type
        //this record is needed only if their is multiple crypto alt coin support
        //first see if there is already a record for this crypto type in the database
        $query = "SELECT * FROM " . TBL_WALLET_BALANCES . " WHERE currency_code= '" . $strCrypto . "' AND userid=" . $intUserID . "";
        //echo "Rate Select SQL = " . $query .  "<br>";
        $rs = mysqli_query($DB_LINK, $query) or die(mysqli_error());
        if (mysqli_num_rows($rs) > 0) {
            $row = mysqli_fetch_array($rs);
            //record found
        }
        if (!$strCrypto_Code) {
            $strCrypto_Code = "btc";
        }
        $query = "INSERT INTO " . TBL_WALLET_BALANCES . " ( user_id, \tcurrency_type, \tcurrency_code,\t    balance\t) VALUES " . " ( {$intUserID},\t'crypto',\t    '{$strCrypto_Code}',  0 ) ";
        //echo "SQL STMNT = " . $query .  "<br>";
        mysqli_query($DB_LINK, $query);
        //$intWalletID = mysqli_insert_id($DB_LINK);
        //make QR Code and save to their directory - google, phpapi
        if ($strWallet_Address) {
            $strQRcodeIMG = PATH_QRCODES . $strWallet_Address . ".png";
            $strError = funct_Billing_GetQRCodeImage($strWallet_Address, $strQRcodeIMG);
            //save img to disk
        }
        //update database with successful code creation
        $query = "UPDATE " . TBL_USERS . " SET flag_qrcodeimg=1 WHERE id=" . $intUserID;
        //echo "SQL STMNT = " . $query .  "<br>";
        mysqli_query($DB_LINK, $query);
        // or die(mysqli_error());
    }
    return $strWallet_Address;
}