php - 更新选定的随机行 PHP

Question

我正在尝试更新数据库中选定的随机行，这是我的 php 代码

$offset_result = mysqli_query($conn, "SELECT FLOOR(RAND() * COUNT(*)) AS `offset` FROM `tbl_combi` WHERE `clear` = 0 ");
$offset_row = mysqli_fetch_object( $offset_result );
$offset = $offset_row->offset;
$result = mysqli_query($conn, "SELECT * FROM `tbl_combi` LIMIT $offset, 1");    
$result_fetch = mysqli_fetch_array($result);

echo $result_fetch[1];

Answer 1

您从未执行任何更新。您可以尝试以下方法(可能需要进行一些调整才能满足您的需求):

$offset_result = mysqli_query($conn, "SELECT FLOOR(RAND() * COUNT(*)) AS `offset` FROM `tbl_combi` WHERE `clear` = 0 ");
$offset_row = mysqli_fetch_object( $offset_result );
$offset = $offset_row->offset;

$updateSql = 'UPDATE tbl_combi SET my_field="my_value" WHERE offset=' . $offset;
mysqli_query($conn, $updateSql);

$result = mysqli_query($conn, "SELECT * FROM `tbl_combi` LIMIT $offset, 1");    
$result_fetch = mysqli_fetch_array($result);

echo $result_fetch[1];