Re: problem with select option - Mailing list pgsql-php

hi list.

i have a script that works initially. here is the script:

<?php
$conn=pg_connect("host=127.0.0.1 dbname=db user=name password=pword");
if (!$conn){
   echo("<P> Unable to connect to the database server at this time.</P>");
    exit();      }
else{$query0="SELECT  municipality  FROM municipality where provinceid=$provid
order by municipality;";
       $result0=pg_exec($conn, $query0);
      }
        $numrows0=pg_numrows($result0);
        $CurrentRow0=0;
        while ($CurrentRow0 < $numrows0) {
       $model0=pg_result($result0, $CurrentRow0);
      echo "<font face=\"Verdana\" size=1><option
value=$model0>$model0</option></font>";
      $CurrentRow0++;
      }
?>

this is only part of the script. when no municipality is chosen, this still
works. what i mean is that it still shows the municipalities in the drop down
box. but if i choose a certain municipality, there will be no municipalities
shown in the drop down box.

i know there's something wrong with the script but i just can't figure it out.
any ideas?

thanks.

ryanne