选择与下拉列表中显示的值不同的值。(PHP和MySQL)

<select name="myList">
  <option value="option1">Option 1</option>
  <option value="option2">Option 2</option>
  <option value="option3">Option 3</option>
</select>

$selectedValue = $_POST['myList'];

$query = "SELECT * FROM your_table WHERE column_name != '$selectedValue'";

// 建立数据库连接
$mysqli = new mysqli("your_host", "your_username", "your_password", "your_database");

// 检查连接是否成功
if ($mysqli->connect_errno) {
    echo "连接数据库失败：" . $mysqli->connect_error;
    exit();
}

// 执行查询
$result = $mysqli->query($query);

// 处理结果
if ($result) {
    while ($row = $result->fetch_assoc()) {
        // 处理每一行的数据
        echo $row['column_name'];
    }
} else {
    echo "查询失败：" . $mysqli->error;
}

// 关闭数据库连接
$mysqli->close();