PHP 代码...查询后我需要更新表

Question

我有一个过滤范围日期的查询，我得到了很好的结果。但在查询之后，我不知道如何更新我想要更改的表行。

事情是这样的

<?php

if (isset($_POST['show'])){
    if (isset($_POST['startDate']))
    $startDate = strtoupper(trim(preg_replace("/[^0-9-]/", "", $_POST['startDate'])));// filter everything but spaces, numbers, and letters
    if (isset($_POST['dateEnd']))
    $dateEnd = strtoupper(trim(preg_replace("/[^0-9-]/", "", $_POST['dateEnd'])));// filter everything but spaces, numbers, and letters
$sql = mysql_query("SELECT * FROM enroll WHERE date >= '$startDate' AND date <= '$dateEnd' AND status = '0' ");
$DisplayList ="";
$enrollList = mysql_num_rows($sql);
if ($enrollList > 0) {
    while($row = mysql_fetch_array($sql)){
        $status = $row['status'];
        $amount = $row['en_amount'];
    if ($status == 0) 
        $st = 'NOT ENROLLED';
        else
        $st = 'ENROLLED';
        $DisplayList .= "<strong>$st</strong><br />";//output the list request
    }
} else {
    $DisplayList = "PLEASE INPUT VALID ENTRIES";
}
}
?>

它显示了一个适合我的列表。过滤器(我认为)很好，我对此没有任何问题。我想问的是之前的查询如何更新状态。我有这个“更新”按钮，如果单击该按钮，我想更新上一​​个查询的范围输出中的行“状态”。我希望我已经解释得很好了。先感谢您。

Answer 1

就像Fred -ii-所说 - 使用更新查询:

$status = 1;
mysql_query("UPDATE enroll SET status = '$status' WHERE date >= '$startDate' AND date <= '$dateEnd' AND status = '0' ");