Using PHP to get data from MSQL and need a button in the foreach table

Let me post some code first so I can explain more of what I want to accomplish.

<?php


require "../config.php";
require "../common.php";

if (isset($_POST['submit'])) {
  if (!hash_equals($_SESSION['csrf'], $_POST['csrf'])) die();

  try  {
    $connection = new PDO($dsn, $username, $password, $options);

    $sql = "SELECT * FROM saledata WHERE itemnumber = :itemnumber";

    $itemnumber = $_POST['itemnumber'];
    $statement = $connection->prepare($sql);
    $statement->bindParam(':itemnumber', $itemnumber, PDO::PARAM_STR);
    $statement->execute();

    $result = $statement->fetchAll();
  } catch(PDOException $error) {
      echo $sql . "<br>" . $error->getMessage();
  }
}
?>
<?php require "templates/header.php"; ?>

<?php  
if (isset($_POST['submit'])) {
  if ($result && $statement->rowCount() > 0) { ?>
    <h2>Results</h2>
<style>
table, th, td {
  border: 1px solid black;
}
</style>
    <table>
      <thead>
        <tr>
        <th>Item Number</th>
        <th>Sale Number</th>
        <th>Lot Number</th>
        <th>Item Description</th>
        <th>Seller Number</th>
        <th>Buyer Number</th>
        <th>Sold</th>
        <th>Sold</th>
        <th>Paid</th>
        <th>Date</th>
        </tr>
      </thead>
      <tbody>
      <?php foreach ($result as $row) : ?>
        <tr>
        <td><?php echo escape($row["itemnumber"]); ?></td>
        <td><?php echo escape($row["salenumber"]); ?></td>
        <td><?php echo escape($row["lotnumber"]); ?></td>
        <td><?php echo escape($row["itemdescription"]); ?></td>
        <td><?php echo escape($row["sellernumber"]); ?></td>
        <td><?php echo escape($row["buyernumber"]); ?></td>
        <td><?php echo escape($row["sold"]); ?></td>
        <td><?php echo escape($row["paid"]); ?></td>
        <td><?php echo escape($row["amount"]); ?></td>
        <td><?php echo escape($row["date"]); ?> </td>
        </tr>
      <?php endforeach; ?>
      </tbody>
    </table>
    <?php } else { ?>
      <blockquote>No results found for <?php echo escape($_POST['itemnumber']); ?>.</blockquote>
    <?php } 
} ?> 

<h2>Find item based on Item Number</h2>

<form method="post">
  <input name="csrf" type="hidden" value="<?php echo escape($_SESSION['csrf']); ?>">
  <label for="itemnumber">Item Number</label>
  <input type="text" id="itemnumber" name="itemnumber"><br><br>
  <input type="submit" name="submit" value="View Results">
</form>

<?php require "templates/footer.php"; ?>
(END)

This produces an HTML table containing the data in the database in rows. What I would like is a button at the beginning or end of the rows that will modify a field in that item's row. An example is the column for sold or not sold. What I would like is a button at either the beginning or the end of each row that modifies the "sold" column from N to Y for that item. I have tried to put a block of code in the code here at the end but I can't get it to do anything. I can get the button to show using the HTML tag but can't get it to actually do anything. Here is the concept of the foreach:

        <td><?php echo escape($row["sold"]); ?></td>
        <td><?php echo escape($row["paid"]); ?></td>
        <td><?php echo escape($row["amount"]); ?></td>
        <td><?php echo escape($row["date"]); ?> </td>
        <td>BUTTON and code to change Sold from N to Y</td>
</tr>

Any assistance would be greatly appreciated! I know my stuff is probably elementary and not very efficient, but I have been working on this project for several weeks and never worked with a MYSQL database before.