Re: problem with select option

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