更新检索的数据

Question

Hi there im in the process of making a page to approve and deny names in a database, I currently have it so it finds an pulls the pending requests im looking for now i wanna know how to update the row once i click approve or deny.

the values it needs to update is the NameState column to either ("approved") or ("REJECTED")

there can be any where from 1 to 100 names at a time.

Thanks Ryan

 $DB_HOST = "IP";
        $DB_USER = "user";
        $DB_PASS = "Pass";
        $DB_DTBS = "DB";
        mysql_connect($DB_HOST, $DB_USER, $DB_PASS) or die(mysql_error()); // Connect to database server(localhost) with username and password.
        mysql_select_db($DB_DTBS) or die(mysql_error()); // Select registration database.

        $search = mysql_query('SELECT * FROM TABLE WHERE `NameState` = \'(\"PENDING")\'') or die(mysql_error()); 

        $match  = mysql_num_rows($search);


        if($match > 0){
            echo "<table border='1'>
                    <tr>
                    <th>ID</th>
                    <th>Current Name</th>
                    <th>Requested Name</th>
                    <th>Approve or Deny</th>
                    </tr>";

            while($row = mysql_fetch_array($search)) {
                echo "<tr>";
                echo "<td>" . $row['object_id'] . "</td>";
                echo "<td>" . $row['Name'] . "</td>";
                echo "<td>" . $row['WishName'] . "</td>";
                echo '<td> <form method="post" action=<?php echo Approve:<input type="radio" value="Approve" name="name"> Deny:<input type="radio" value="Deny" name="name"><br /> </td>';
                echo "</tr>";
            }

            echo "</table>";

            echo '<input type="Submit" value="Submit" name="Submit"> </form>';

        } else {
            echo("No Names to Approve");
        }

    ?>