Update table data based on dropdown box selection
<p>I have an html table of data with a drop down box in each row.  If a user changes the value of the drop down box, I want the data in that row to change (based on a database call to lookup the associated data for the new value of the dropdown box).</p>

<p>As a basic example, suppose a table showed players on a basketball team along with their heights.  Imagine the player is selected from a drop down box...I want the height for that player to change in the html table if the user changes the player in that row with the drop down box.  For example, if in the table below the user changed the player of Kobe Bryant to some other player (like to Ray Allen), the Height column would change based on a database lookup of Ray Allen's height.</p>

<pre><code>Player           Height
[Kobe Bryant V]   6'6"
[Dwyane Wade V]   6'4"
</code></pre>

<p>I would like to do this using jquery or javascript.  Also, I'm using CakePHP for my site, but that may not be relevant if this is all handled by jquery or javascript.  Thanks for any help!
Ryan</p>
