title: PHP get value under mysql row
body: <p>I'm trying to get a value that is associated (through mysql data-base row) to a unique Id through an option form:</p>
  
  <pre><code>&lt;form&gt;
  &lt;td&gt;
  &lt;select name='rolo'&gt;
     &lt;option value='$id'&gt;$item&lt;/option&gt;
  &lt;/td&gt;
  &lt;td&gt;
     $value
  &lt;/td&gt;
  &lt;/select&gt;
  &lt;/form&gt;
  </code></pre>
  
  <p>So, when I choose an option, I get the correspondent $value associated with it in the next .</p>
  
  <p>What I have tried so far:</p>
  
  <pre><code>$query = "SELECT * FROM rolostock WHERE id='$id' ";
  $result = mysql_query($query);
  while ($row = mysql_fetch_array($result)) {
  echo $row['value'];
  }
  </code></pre>
  
  <p>I am not a php expertise, and I thought this would do it? Thanks in advance!</p>
  
  <p>EDIT:</p>
  
  <p>What i'm trying is to (html form) SELECT > OPTION $id > (php) get $value of $id in the next (html) TD . :\</p>