title: I have PHP populating a Dropdown box, and I want it to also populate two read only Text boxs from the same Table
body: <p>I have a table called Parts, (PartID, PartName, Cost) and I have PHP populating a Drop down box with the PartID's. I want it to when a user selects a Part ID, it populates one text box with the Part's name and the other box, with the Part's cost.<br>
   Here's what my Code look's like for the drop down box if it helps any :)</p>
  
  <pre><code>$sql = "SELECT PartID FROM Parts WHERE PartID LIKE 'C0%'";
  $result = mysql_query($sql);
  
  echo "&lt;select name='PartID'&gt;";
  
  while ($row = mysql_fetch_array($result)) 
  {
  echo "&lt;option value='" . $row['PartID'] . "'&gt;" . $row['PartID'] . "&lt;/option&gt;";
  }
  echo "&lt;/select&gt;";
  </code></pre>