<?php

     if(isset($_POST['submit'])){
        $artistName = $_POST['artistName'];
     if(isset($_GET['go'])){
     if(preg_match("/^[A-Za-z]+/", $_POST['artistName'])){

      include 'include/connect.php';

     $sql = "SELECT artistName, albumName, albumID, cost, stock FROM album inner join artist on album.artistID = artist.artistID WHERE artistName LIKE '%" .$artistName. "%'";

     $result = $con->query($sql);
     echo '<table><tr><th>Artist</th><th>Album</th><th>Cost</th><th>Stock</th><th>Purchase</th></tr>';
        $quantity = '';
        while ($row = $result->fetch_array()) {

        $albumName=$row['albumName'];
        $cost=$row['cost'];
        $albumID=$row['albumID'];
        $stock=$row['stock'];

        echo '<tr>';
        echo '<td>' . $artistName . '</td>';
        echo '<td>' . $albumName . '</td>';
        echo '<td>' . $cost . '</td>';
        echo '<td>' . $stock . '</td>';
        //echo "<td> <input name=\"albumID[]\"type=\"text\" $albumID </td></tr>";
        echo "<td><input type='text' name='qauntity[]' value='".$row['quantity']."' /></td>";
    }
    echo "</table>";
    echo '<td><a href="update-stock.php?id=' . $albumID .'">Purchase</a></td>';
   }
   }
  }
?>