<table>
<tr><td><font COLOR=#000000 STYLE = "background-color: 669900" FACE="Arial" SIZE=3> Vali loom: </font></td><td>

<select name = "animal" id = "animal" >

<?php

$dbconn = pg_pconnect("host=localhost port=5432 dbname=jahitellimuste_db user=postgres password=zuljen");

$result = pg_query($dbconn, "SELECT loom_id, nimetus FROM loom"); //        //echo "<option value = '".$row['loom_id']."'>".$row['nimetus']."</option>\n";

  while($row = pg_fetch_assoc($result))  {
    $id = $row['loom_id'];
    $nimetus = $row['nimetus'];
    echo "<option value = \"${id}\" >${nimetus}</option>\n";
  }

  pg_close($dbconn);

 ?>
  </select>
  </table>