我正在尝试使用SQL SERVER和PHP插入上一次选择的结果字段，但无法正常工作

<?php
// 连接到SQL Server数据库
$serverName = "your_server_name";
$connectionOptions = array(
    "Database" => "your_database_name",
    "Uid" => "your_username",
    "PWD" => "your_password"
);
$conn = sqlsrv_connect($serverName, $connectionOptions);

if ($conn === false) {
    die(print_r(sqlsrv_errors(), true));
}

// 执行查询语句
$sql = "SELECT * FROM your_table";
$stmt = sqlsrv_query($conn, $sql);
if ($stmt === false) {
    die(print_r(sqlsrv_errors(), true));
}

// 获取查询结果的字段值
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
    $fieldValue = $row['your_field_name'];

    // 执行插入操作
    $insertSql = "INSERT INTO your_target_table (target_field) VALUES ('$fieldValue')";
    $insertStmt = sqlsrv_query($conn, $insertSql);
    if ($insertStmt === false) {
        die(print_r(sqlsrv_errors(), true));
    }
}

// 关闭数据库连接
sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);
?>