title: fill other text inputs with MySQL values based on select box option
body: <p>I have this select box that populates from MySQL Data using PHP</p>
  
  <pre><code>&lt;select&gt;
      &lt;?php
      $stmt = $pdo_conn-&gt;prepare("SELECT * from prices ");
      $stmt-&gt;execute(array());
      $records = $stmt-&gt;fetchAll(PDO::FETCH_ASSOC);
      foreach($records as $result2) {
          echo '&lt;option value="'.$result2["product"].'"&gt;'.$result2["product"].'&lt;/option&gt;';
      }
      ?&gt;
      &lt;/select&gt;
  </code></pre>
  
  <p>in the same table in MySQL (prices) there is a retail column, how can i put the value of retail into a text input </p>
  
  <pre><code>&lt;input type="text" name="unitprice" /&gt;
  </code></pre>
  
  <p>based on the selected row in the select box?</p>