title: Dynamic SELECT TAG filled from MYSQL DB
body: <p>I have problem. I need make dynamic SELECT tag where OPTIONS are filled dynamically from mySQL DB. I have this code but it doesnt work. So if you have some corrects or idea how to make it other way I will be very thankuf:) Thanks alot!</p>
  
  <pre><code>&lt;SELECT&gt;
  &lt;?php
   $con = mysql_connect("localhost", "root", "123456");
  mysql_select_db("aplikace",$con);
  $result = ("SELECT * kod FROM protokoly".
  "ORDER BY kod");
  $rs = mysql_query($result);
  $nr = mysql_num_rows($rs);
  for ($i=0; $i&lt;$nr; $i++) {
      $r = mysql_fetch_array($rs);
      echo "&lt;OPTION VALUE=\"".$r["kod"]."\"&gt;".$r["kod"]."&lt;/OPTION&gt;";
  }
  ?&gt;
  &lt;/SELECT&gt;
  </code></pre>