php - PHP Mysql Max+1 在同一张表中

Question

在 PHP 更新查询中，Max+1 在本地工作，但在托管方面不适合我，请帮忙

 if (isset($_POST['submit'])) {
  if (!empty($_POST['PaidY'])) {
    $selected_ids = array();
    foreach ($_POST['PaidY'] as $selected) {
      $selected_ids[] = $selected;
    }
    $included_ids = implode(" ", $selected_ids);
    $sql = "UPDATE fees SET Receiptno= (SELECT MAX(Receiptno) + 1 FROM fees), Paiddate= '$Paiddate', PaidY = '1' WHERE id in (" . $included_ids . ")";
    $pdo->query($sql);
    header("Location: feespaid_list.php");
  }
}

Receiptno= (SELECT MAX(Receiptno) + 1 FROM fee)，这部分在本地工作，但在托管中不适合我，我检查了一个数字而不是在托管中工作的 Max+1 方程。谢谢

标签： phpmysql